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

181 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
draftee1137952(None) 
drafted12439031drafted
draftees12225251draftees
drafter11449421drafter
crafted13419772crafted
crafter124111332crafter
dafter104813342d_after
draft95526682draft__
drafters12338522drafters
draftier1285262draftier
drafts105012532draft_s
drafty13638932draft_y
dragee84415602dra_gee
dratted9358592dratted
drawee104413822dra_wee
drifted12367952drifted
drifter11348702drifter
grafted124110222grafted
grafter114211152grafter
grantee83217132grantee
rafted104714702_rafted
rafter94517582_rafter
after85719793__after
bracted12410933bracted
brattle9249253brattle
coatee84327223coa_tee
craft105327663craft__
crafters13419953crafters
craftier1376193craftier
crafts115312743craft_s
crafty14478913craft_y
crate76537403cra_t_e
crated94827773cra_ted
crater85026643cra_ter
crates85736063cra_tes
crofter12299573crofter
daffed14429493d_affed
daft85537253d_aft__
daftest11248943d_aftest
daftly1335443d_aftly
darted84620923d_arted
darter75320363d_arter
dartle73714833d_artle
date56443323d_a_t_e
dated75530993d_a_ted
dater65332313d_a_ter
dates65639153d_a_tes
dauted84114933d_auted
dautie72914703d_autie
dawted11489683d_awted
dawtie103011093d_awtie
deafen10389673deaf_en
deafer104114813deaf_er
defter104215923d_efter
departee1139723departee
derate74531233dera_t_e
derated93623503dera_ted
derates84028893dera_tes
deratted1048403deratted
devotee113811823devotee
diastem10318043diastem
diaster82813313diaster
doated84118183doa_ted
drabbed13428723drabbed
drabber12438593drabber
drabbet12319573drabbet
drabble12238883drabble
draff125615663draf__f
draffier1574323draffier
draffs13617903draf_fs
draffy16486633draf_fy
draftable1575563draftable
draftiest1335943draftiest
draftily1534413draftily
drafting13339403drafting
draftsmen1552673draftsmen
dragees9359483dragees
dragged11379563dragged
dragger10309173dragger
draggle1056103draggle
dragnet91211433dragnet
dragster1034623dragster
drained93713253drained
drainer83012843drainer
drake104918303dra__ke
drakes114715863dra_kes
drammed13378073drammed
drape85319633dra__pe
draped105314363dra_ped
draper94315693dra_per
drapes95419653dra_pes
drapey125010583dra_pey
drastic10310873drastic
drat56247833dra_t__
drats66628373dra_t_s
drave95219273dra__ve
drawees11378363drawees
drawer104711363dra_wer
drawled12368343drawled
drawler11338593drawler
drawtube1441603drawtube
drayage1234423drayage
drayed115911393dra_yed
draymen1335233draymen
dree56638323dr___ee
drift95722843drift__
driftage1342933driftage
drifters12417913drifters
driftier1275123driftier
drifts10499893drift_s
drifty13418223drift_y
fracted1339373fracted
frater94520593fra_ter
giftee103512083_giftee
goatee73219533goa_tee
graft95327203graft__
graftage1343683graftage
grafters12409193grafters
grafts105013253graft_s
grandee93115513grandee
granted94715103granted
grantees92510973grantees
granter84117133granter
grate64932883gra_t_e
grated84523923gra_ted
grater74625443gra_ter
grates75429893gra_tes
grifted12379583grifted
grifter113810493grifter
hafted134713833_hafted
hafter124815883_hafter
irate55627983ira_t_e
irater65218353ira_ter
kraft125721013kraft__
krafts13438853kraft_s
krater104014313kra_ter
orate55133303ora_t_e
orated74221503ora_ted
orates64328613ora_tes
pattee84323383_pattee
prate75135983pra_t_e
prated94924923pra_ted
prater84825353pra_ter
prates84633163pra_tes
prattle9208833prattle
raffle123910703_raffle
raft76245913_raft__
raftered1237663_raftered
rafters103715633_rafters
rafts87820633_raft_s
ragee65432663_ra_gee
raggee84217603_raggee
rakee96031173_ra_kee
ramee74633853_ra_mee
ranee55438103_ra_nee
ranted74324703_ranted
ranter63826823_ranter
rappee103618673_rappee
raster64731443_raster
rate45458763_ra_t_e
rated65441383_ra_ted
ratel54224883_ra_tel
rater54943283_ra_ter
rates55352013_ra_tes
rathe85821923_ra_the
ratted74923343_ratted
ratteen7329113_ratteen
ratten64217383_ratten
ratter64326313_ratter
rattle64717613_rattle
razee145827803_ra_zee
redrafted1435143redrafted
rifted104115313_rifted
shafted14288813shafted
trainee72817793trainee
trustee73514443trustee
urate55432163ura_t_e
urates65027763ura_tes
wafted134012143_wafted
wafter124114613_wafter
wrastle10368993wrastle

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.1561145455.1
2DLD Change Limit1340271816.00022337.8
3Display Results1811810.0632873.0
 (SQL Overall)1786911816.21928733.1
 
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.