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

241 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
current931369(None) 
currant9314171currant
currents1038371currents
correct11513982correct
curet75447642cu_re_t
curran8312022curran_
currans9310612currans
currants1037932currants
curred94319262curre_d
currency1545542currency
currently1445092currently
curring103616842curring
curtest9713962curtest
curvet114720242curve_t
decurrent1256452decurrent
excurrent1844042excurrent
horrent10313552horrent
incurrent1147122incurrent
occurrent1344272occurrent
recurrent1146712recurrent
subrent9315082subrent
torrent7313412torrent
turgent8712392turgent
turret63121852turre_t
uncurrent1145672uncurrent
unrent63219782_unrent
urgent73816042_urgent
ardent73022613_ardent
argent74023663_argent
arpent84822093_arpent
arrant6623253_arrant
arrest63722633_arrest
audient8312303audient
augment10910203augment
barren85317613barren_
barrens94414323barrens
barret84930483barre_t
brent75734133__brent
burden9412473burden_
burdens1039713burdens
buret77444013bu_re_t
burnet84326173burne_t
burnt75230333bu_r_nt
burred95820723burre_d
burrer83718473burre_r
burrers93814493burrers
burriest102911213burriest
burring104016993burring
cadent94120363c_adent
candent10417363candent
careen84119493careen_
careens94514703careens
caret75360563c_are_t
carmen104019343carmen_
carnet84732873carne_t
carpet104530093carpe_t
carrel84718633carre_l
carrell94610473carrell
carrels95117303carrels
carrot8423123carr_ot
carven114716663carven_
cement103321673c_ement
cent67451013c___ent
cerement12315133cerement
cermet10321153cerme_t
chirren12388743chirren_
cholent12313253cholent
churred13409173churre_d
churring14298653churring
claret84026573clare_t
clement11313773clement
client8316343c_lient
coagent10313983coagent
coerect11913353coerect
cogent9321003c_ogent
coherent13412473coherent
comment1310317703comment
concent114422513concent
concurrent1446313concurrent
consent93723113consent
content94326153content
convent123919413convent
coparent12412253coparent
cornet84436733corne_t
coronet94227173coronet
corrects1259573corrects
corrupt1149103corrupt
corset85636223corse_t
corvet114626933corve_t
courant9317973courant
credent10313973credent
crept95125893c__rept
crest74632693c__rest
crudest104510333crudest
cruet74831843c_rue_t
cruset84425093cruse_t
culet76040343cu_le_t
cullet84727313culle_t
culvert123011773culvert
cunt66243673cu___nt
curare84916953curare__
curares94916853curare_s
curarine10610713curarine
curbed114615873curbe_d
curber104517053curbe_r
curbers115514383curbers
curbing123814023curbing
curded104217163curde_d
curdiest112511393curdiest
curding113515133curding
cure66149123cu_re__
cured85932133cu_re_d
curer75030753cu_re_r
curers84923193cu_rers
cures75645433cu_re_s
curets84922343cu_rets
curette939783cu_rette
curfew14426743curfe_w
curfews15294913curfews
curie74533043curie__
curies84934023curie_s
curing94824783cu_ring
curled95021653curle_d
curler85221323curle_r
curlers94218073curlers
curlew114010903curle_w
curlews12387393curlews
curliest102713123curliest
curling104320183curling
curn66731893cu_r_n_
curns74924283cu_r_ns
curr65429653curr___
currach1446453currach
curragh1344293curragh
currejong1951663currejong
currie84317263curr_ie
curried103313653curried
currier93316703currier
curriers103410753curriers
curriery13326163curriery
curries93723163curries
currish1238353currish
currs75624393curr__s
curry105920343curr__y
currying14196493currying
curse75829143curse__
cursed94321253curse_d
curser84721473curse_r
cursers94317163cursers
curses85328273curse_s
cursing104217033cursing
curst74931023cu_r_st
curt67051713cu_r__t
curter85320083curte_r
curtesy1265833curtesy
curve104920023curve__
curved124815223curve_d
curves114619283curve_s
curvets12399913curvets
curvey144111843curve_y
curviest13309673curviest
curving133912103curving
cutest85820143cu_test
cutlet84924363cutle_t
errant6618733_errant
esurient849293esurient
ferment12315573ferment
ferret93021173ferre_t
fervent13310063fervent
fornent10312933fornent
forwent13310533forwent
fulgent1138903fulgent
furmenty1645293furmenty
furred104514433furre_d
furriest112910793furriest
furring114013143furring
garment10315233garment
garret74426563garre_t
gerent73223103_gerent
gurnet74920873gurne_t
hutment1239173hutment
jurant134216553ju_rant
lucent8313823lu_cent
margent10316693margent
mordent10313993mordent
murkest133110203murkest
murre74821073murre__
murrelet10167573murrelet
murres85019043murre_s
murrey114312263murre_y
murreys12367323murreys
murrine9411483murrine
noncurrent1255513noncurrent
nutrient848353nutrient
occurrents1453003occurrents
orient6322533_orient
outwent10311363outwent
parent83230423_parent
percent113520603percent
perpent112318813perpent
porrect1159743porrect
portent93619643portent
prudent10310433prudent
prurient1048233prurient
pungent10311233pungent
purest84021933pu_rest
purred94218073purre_d
purring104515823purring
purulent1047613purulent
quitrent1746963quitrent
rent46661243___rent
rerent63832453_rerent
sarment9318763sarment
serpent92916283serpent
sorbent92915243sorbent
sprent84522383_sprent
subrents10310293subrents
surest65026763su_rest
surfeit10310343surfeit
surprint1049533surprint
surreal739233surreal
surrey94414583surre_y
surreys10489443surreys
terrene72411033terrene
terret63425623terre_t
torment9316173torment
torrents838143torrents
tureen63312723tureen_
tureens7289873tureens
turrets73010673turrets
unbent83216593_unbent
unkent103116053_unkent
unpent83117373_unpent
unrest62918853_unrest
unsent63820963_unsent
upsent83314063_upsent
urtext1337433_urtext
varment12313243varment
warrant10614243warrant
warren95012853warren_
warrens103810893warrens

Search took 9 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.423422437.4
2DLD Change Limit1340272417.98316789.1
3Display Results2412410.0962510.4
 (SQL Overall)1786912418.50221017.5
 
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.