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

56 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
updraft134603(None) 
updrafts1443201updrafts
draft95526682__draft
indraft1199572indraft
redraft11310572redraft
updart9310742upd_art
upwaft1444942up_waft
adrift10313113_adrift
craft105327663__craft
daft85537253__d_aft
draff125615663__draff
drafts105012533__drafts
drafty13638933__drafty
drat56247833__dra_t
drift95722843__drift
engraft11118623engraft
graft95327203__graft
hydrant1489053hydrant
indrafts1295583indrafts
ingraft1199503ingraft
kraft125721013__kraft
operant9317223operant
prat65952043_p_ra_t
predraft1447593predraft
quadrant1858083quadrant
quadrat1769273quadra_t
raft76245913___raft
redrafts1235603redrafts
regraft11310153regraft
spirant9814293spirant
sprat76635973sp_ra_t
underact11311513underact
undrape1049333undrape
undraw1037813undra_w
undrawn1145293undrawn
undraws1136893undraws
undreamt1156543undreamt
undrest8313013undrest
upbeat10911513upbea_t
upbraid1244973upbraid
upcast102710093up_cast
upcoast1165543upcoast
updarts1034203updarts
update93810293upd_ate
updried11226473updried
updries10209083updries
updry1135483updr__y
upfront1246973upfront
upgrade11215823upgrade
upleapt11116863upleapt
uplift114610653up_lift
uprate83916543up_rate
uproot8314123up_root
upshift1545113upshift
upstart9159753upstart
upwafts1541943up_wafts

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 Filter1786911340270.436409841.7
2DLD Change Limit134027566.01622278.4
3Display Results56560.0163500.0
 (SQL Overall)178691566.46827626.9
 
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.