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 “draftees” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

126 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
draftees1222525(None) 
draftee11379521draftee_
drafters12338531drafters
crafters13419952crafters
drafted12439032draft_ed
drafter11449432draft_er
draftier1285262draftier
draftiest1335942draftiest
drafts105012532draft__s
dragees9359482dra_gees
drawees11378362dra_wees
drifters12417912drifters
grafters12409192grafters
grantees92510972grantees
rafters103715632_rafters
afters94717073__afters
brattles10199333brattles
coatees93816553coa_tees
crafted13419773craft_ed
crafter124111333craft_er
craftier1376193craftier
craftiest1436913craftiest
crafts115312743craft__s
craters95021893cra_ters
crates85736063cra_t_es
crofters13358903crofters
dafter104813343d_aft_er
daftest11248943d_aftest
daftness1235533d_aftness
darters84017603d_arters
dartles84014133d_artles
daters74827373d_a_ters
dates65639153d_a_t_es
dauties83315763d_auties
dawties113312703d_awties
deafens11317253deaf_ens
deafness1236213deafness
departees1265723departees
derates84028893dera_t_es
devotees12286283devotees
diabetes1147023diabetes
diastems11226523diastems
diasters92913183diasters
drabbets13294823drabbets
drabbles13308523drabbles
drabness1135803drabness
draffier1574323draffier
draffiest1644363draffiest
draffs13617903draf__fs
draft95526683draft___
draftily1534413draftily
draftiness1444863draftiness
drafting13339413drafting
draftings14334213draftings
draftsmen1552673draftsmen
drafty13638933draft__y
dragee84415603dra_gee_
draggers11357393draggers
draggles1145963draggles
dragnets10136563dragnets
dragsters1134333dragsters
drainers92811253drainers
drakes114715863dra__kes
drapers105313353dra_pers
drapes95419653dra__pes
drats66628373dra_t__s
dratted9358593dra_tted
drawee104413823dra_wee_
drawers113610073dra_wers
drawlers12307313drawlers
drawtubes1541653drawtubes
drayages1344513drayages
drees65628523dr___ees
driftages1453153driftages
drifted12367953drift_ed
drifter11348703drift_er
driftier1275123driftier
driftiest1335943driftiest
drifts10499893drift__s
fraters103517213fra_ters
giftees11306513_giftees
goatees82710443goa_tees
graftages1443683graftages
grafted124110223graft_ed
grafter114211153graft_er
grafts105013253graft__s
grandees103211283grandees
grantee83217133grantee_
granters93614143granters
graters85419743gra_ters
grates75429893gra_t_es
grifters12389233grifters
hafters134614333_hafters
krafts13438853kraft__s
kraters114212343kra_ters
orates64328613ora_t_es
praters94921653pra_ters
prates84633163pra_t_es
prattles10189403prattles
raffles133611843_raffles
rafted104714703_raft_ed
rafter94517583_raft_er
raftered1237663_raftered
rafts87820633_raft__s
ragees74618663_ra_gees
raggees93710913_raggees
rakees104516973_ra_kees
ramees84620893_ra_mees
ranees64623963_ra_nees
ranters73323643_ranters
rappees113611453_rappees
rasters74629023_rasters
ratels64518213_ra_tels
raters63936583_ra_ters
rates55352013_ra_t_es
ratteen7329113_ratteen
ratteens8256053_ratteens
rattens74213403_rattens
ratters74422473_ratters
rattles73217303_rattles
razees154314763_ra_zees
trainees82712063trainees
trustees8339323trustees
urates65027763ura_t_es
wafters134112813_wafters
wrastles11328933wrastles

Search took 8 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.406440125.6
2DLD Change Limit1461621266.75021653.6
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.20224811.3
 
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.