Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “preguide” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
preguide125542(None) 
preguided1443921preguided
preguides1344861preguides
prelude1038012prelu_de
preside10715612pre_side
beguile1056933_beguile
beguine1068503_beguine
guide75019883___guide
misguide12145703misguide
oreide7311673ore__ide
outguide1045953outguide
paraglide1345703paraglide
peglike14136773p_eglike
peptide122910683p_eptide
peregrine1247043peregrine
peroxide1848173peroxide
persuade1145853persuade
pinguid1146243pinguid_
preaudit1177023preaudit
prebade12310283pre_bade
prebid113512843pre_bid_
prebids12399883pre_bids
prebuild1344303prebuild
prebuilds1442633prebuilds
prebuilt1247033prebuilt
precede1239643pre_cede
precipe133012123pre_cipe
precise113518173pre_cise
preclude1344903preclude
precode12311853pre_code
precure11312553precu_re
precured1339993precured
predive13511083pre_dive
predried12309573predried
preemie11310563preemi_e
prefade1339013pre_fade
prefile123413183pre_file
prefire124012813pre_fire
prefund1335733prefund_
prefunded1644693prefunded
prefunds1454693prefunds
pregame1239553preg_ame
preguiding1544493preguiding
prejudge1943203prejudge
prejudice2143343prejudice
prelife1279943pre_life
preluded1236463prelu_ded
preluder1135733prelu_der
preludes1137833prelu_des
prelusive1455583prelusive
premade12311443pre_made
premie103617993pre_mi_e
premise113818553pre_mise
premune1138933premu_ne
prentice121012353prentice
prepaid12310133prepaid_
preppie1058093preppi_e
preprice1488873preprice
prepuce1337833prepu_ce
prepupae1144643prepupae
presided12410553pre_sided
presider11410423pre_sider
presides11414913pre_sides
preslice1258623preslice
prestige11310733prestige
presume11310303presu_me
presumed1337973presumed
prettied1159253prettied
preunite1039573preunite
previse123713793pre_vise
prevue1179163prevu__e
prevued1337143prevued_
prevuing1457253prevuing
prewire124311133pre_wire
pride84724733pr___ide
prograde1247183prograde
proteide11239723proteide
provide1339853pr_ovide
prude84615973pr__u_de
regicide1245923_regicide
regime95313943_reg_ime
regive104814323_reg_ive
regrade92612033_regrade
reguline939503_reguline
require16148653_require
requite162012483_requite
reside74224933_re_side
ureide7310363ure__ide
waveguide1751073waveguide

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.1731032896.0
2DLD Change Limit146162896.60622125.6
3Display Results89890.0332697.0
 (SQL Overall)178691896.81226231.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.