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 “preguided” 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.

64 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
preguided144392(None) 
preguide1255421preguide_
preguides1344861preguides
prefunded1644692prefunded
preluded1236472prelu_ded
presided12410552pre_sided
beguiled1244443_beguiled
guided94014113___guided
misguided14144653misguided
outguided1264573outguided
paraglided1543253paraglided
peroxided2045073peroxided
persuaded1344373persuaded
preboiled1455783preboiled
prebuild1344303prebui_ld
preceded1438293pre_ceded
precised133213413pre_cised
precited133013813pre_cited
precluded1544223precluded
precoded1438863pre_coded
precured1339993precu_red
predried12309573predri_ed
preedited1337633preedited
prefaded1537823pre_faded
prefiled143310573pre_filed
prefired144310753pre_fired
prefixed21357703pre_fixed
preguiding1544493preguiding
prejudged2142753prejudged
prejudiced2342543prejudiced
preloaded1335923preloaded
prelude1038013prelu_de_
preluder1135733prelu_der
preludes1137833prelu_des
premised133013193pre_mised
premixed20338013pre_mixed
premolded1544683premolded
prenticed14118063prenticed
prepriced1676643prepriced
prescinded1644343prescinded
preside10715613pre_side_
presider11410423pre_sider
presides11414913pre_sides
presliced1435983presliced
presumed1337973presu_med
pretended1337193pretended
prettied1159253pretti_ed
preunited1246803preunited
prevailed1536043prevailed
prevised143611073pre_vised
prevued1337143prevu__ed
prewired14358473pre_wired
prided103618033pr___ided
provided1536843pr_ovided
rebuilded1342743_rebuilded
refunded1336953_refunded
regained102111243_regained
regarded11279803_regarded
regilded1135543_regilded
regraded113410763_regraded
required18156833_required
requited18169723_requited
resided95217703_re_sided
unguided1136233_unguided

Search took 10 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 Filter1786911486410.440406115.9
2DLD Change Limit148641649.34315909.3
3Display Results64640.0302133.3
 (SQL Overall)178691649.81318209.6
 
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.