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

150 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
currents103837(None) 
currants1037931currants
current9313691current_
corrects1259572corrects
curets84922342cu_re_ts
currans9310612curran_s
currant9314172currant_
currency1545542currency
currently1445092currently
curvets12399912curve_ts
occurrents1453002occurrents
subrents10310292subrents
torrents838142torrents
turrets73010672turre_ts
argents84014853_argents
arpents93613083_arpents
arrests73312683_arrests
audients946353audients
augments1137833augments
barrens94414323barren_s
barrets94917103barre_ts
brents84717273__brents
burdens1039713burden_s
burets84321263bu_re_ts
burnets93813263burne_ts
burrers93814493burre_rs
careens94514703careen_s
carets85330773c_are_ts
carnets93918403carne_ts
carpets113915333carpe_ts
carrells10359273carrells
carrels95117303carre_ls
carrots9714623carr_ots
cements112714223c_ements
cents74730333c___ents
cerements13411453cerements
cermets1139713cerme_ts
cholents1337623cholents
clarets94111103clare_ts
clients938093c_lients
coagents1138453coagents
coerects1258543coerects
comments142913883comments
concents122516603concents
concurrents1554563concurrents
consents102715893consents
contents104018213contents
convents132614603convents
coparents1347973coparents
cornets94820573corne_ts
coronets103814363coronets
correct11513983correct_
corrupts1244983corrupts
corsets94819803corse_ts
corvets124715023corve_ts
courants10310803courants
crests85218703c__rests
cruets85314953c_rue_ts
crusets93811043cruse_ts
culets85518513cu_le_ts
cullets94015613culle_ts
culverts13295323culverts
cunts76125123cu___nts
cupreous1255603cupreous
curares94916853curare__s
curarines11710553curarines
curbers115514383curbe_rs
curbings13407313curbings
curers84923193cu_re_rs
cures75645433cu_re__s
curet75447643cu_re_t_
curette939783cu_rette
curettes1039313cu_rettes
curfews15294913curfe_ws
curies84934023curie__s
curlers94218073curle_rs
curlews12387393curle_ws
curlings114110383curlings
curns74924283cu_r_n_s
currachs1544543currachs
curraghs1442883curraghs
curran8312023curran__
curred94319263curre__d
currejongs2051273currejongs
currencies1445663currencies
currentness1352823currentness
curriers103410753curriers
curries93723163curr_ies
curring103616843currin_g
currs75624393curr___s
cursers94317163curse_rs
curses85328273curse__s
curtest9713963curtest_
curtness1037263curtness
curves114619283curve__s
curvet114720243curve_t_
cutlets94113653cutle_ts
decurrent1256453decurrent_
errants7410643_errants
excurrent1844043excurrent_
ferments13311473ferments
ferrets103111393ferre_ts
furmenty1645293furmenty
furrings12317143furrings
garments1139963garments
garrets84413623garre_ts
gerents82612923_gerents
gurnets84010793gurne_ts
horrent10313553horrent_
hutments1345603hutments
incurrent1147123incurrent_
jurants14379213ju_rants
margents11410133margents
mordents1138813mordents
murrelets11123243murrelets
murres85019043murre__s
murreys12367323murre_ys
nutrients944423nutrients
occurrent1344273occurrent_
orients7311583_orients
parents93418123_parents
percents122713373percents
perpents122312043perpents
portents103512823portents
quitrents1843893quitrents
recurrent1146713recurrent_
rents55935183___rents
rerents73319423_rerents
sarments10311963sarments
serpents102410373serpents
sorbents10279133sorbents
subrent9315083subrent_
surfeits1146223surfeits
surprints1145283surprints
surreys10489443surre_ys
terrenes82212603terrenes
terrets72913583terre_ts
torments10310453torments
torrent7313413torrent_
tureens7289873tureen_s
turgent8712393turgent_
turret63121853turre_t_
uncurrent1145673uncurrent_
unrent63219783_unrent_
unrests7229463_unrests
urgent73816043_urgent_
urtexts1433143_urtexts
varments1339063varments
warrants1168503warrants
warrens103810893warren_s

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621506.37322934.6
3Display Results1501500.0632381.0
 (SQL Overall)1786911506.85926052.0
 
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.