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

135 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
diluent831026(None) 
diluents946061diluents
abluent939622abluent
ailment9314232ailment
diligent1048032diligent
dissent84018682dissent
distent84120852distent
eluent6315482_eluent
fluent9313932_fluent
silent64125842sil_ent
abluents1045473abluents
affluent1494563affluent
ailments1039443ailments
aliment9316703aliment
bailment1249183bailment
billet86029723bille_t
blent76230953_bl_ent
bluest84016483_bluest
bluet75631193_blue_t
blunt75525023_blu_nt
client8316343_client
daunt65929083d_au_nt
decent94023703d_ecent
dement93825153d_ement
dent57158413d___ent
descent102616293descent
detent73624483d_etent
devilment1547713devilment
dialect101210263dialect
diciest103316523diciest
dickens144410133dickens
diene65720133di__ene
diet57357543di__e_t
digest84019623di_gest
dilatant948203dilatant
dilled84122223dille_d
dilute72911803dilu_te
diluted9248933diluted
diluter8319663diluter
diluters9288113diluters
dilutes82911973dilutes
diluting10248983diluting
dilutor8256013dilutor
diluvia11225253diluvia
dimmest1249253dimmest
dint56759063di___nt
diplont10311693diplont
dipnet91317473dipne_t
diquat1639763diqu_at
direct93817333di_rect
direst75024243di_rest
diriment11410743diriment
discant103017263discant
discept12310623discept
disject17268673disject
dispend11289413dispend
disseat83816923disseat
dissect103614133dissect
dissents93411863dissents
dissert83720693dissert
distant83519953distant
distend93312073distend
divalent1247783divalent
divert103922813di_vert
divest106820073di_vest
dizen155214933di_zen_
dizens164911393di_zens
docent92918683d_ocent
document1348663document
dolmen93911373dolmen_
dolmens10388693dolmens
duet56446263d__ue_t
dulcet9314493dulce_t
dullest8312633dullest
dunt55746873d__u_nt
effluent14134413effluent
eluant6315093_eluant
eluents738703_eluents
figment1379743figment
filament13410033filament
filbert12411643filbert
filet85540163fil_e_t
fillet95027083fille_t
fitment12710303fitment
fulgent1138903fulgent
gilbert10310763gilbert
gillnet839733gillnet
idlest74014863idl_est
illest63615723_illest
incent83320723_incent
indent73021243_indent
influent1147633influent
intent63122773_intent
invent93316363_invent
lent46360533__l_ent
lucent8313823__lucent
lunet56835423__lunet
lunt46148843__lu_nt
milden94113153milden_
mildens10339933mildens
mildest102812063mildest
millet84030743mille_t
minuend1035383minuend
minuet82621033minue_t
missent94318713missent
oiliest72817683oiliest
oilmen848313oilmen_
opulent938833opulent
pigment12510733pigment
piquant1848003piquant
piquet17412353pique_t
refluent1147443refluent
relent64431853rel_ent
relucent1049283relucent
rident7520193ri_dent
rillet64828853rille_t
ringent8315153ringent
salient7419763salient
sequent16410323sequent
sileni63312143sil_eni
silents73514493sil_ents
silken104410853silken_
sklent103614353skl_ent
solvent10310833solvent
splent84720193spl_ent
talent6323323tal_ent
toluene736463toluene
unguent839123unguent
vilest9416843vil_est
violent102110813violent
virulent1146433virulent
wildest113311273wildest
wiliest103416593wiliest
willet95124833wille_t
wisent93516343wi_sent

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271357.09618887.7
3Display Results1351350.0433139.5
 (SQL Overall)1786911357.52923733.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.