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

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

105 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
dienes7571990(None) 
denes65639721d_enes
diene65720131diene_
dieses75218691dieses
dines66449151di_nes
agenes74720252agenes
akenes104817342akenes
arenes64928392arenes
benes75536232_benes
bines76946792bi_nes
cines75239682ci_nes
dees56356632d_e_es
deices94119372deices
dekes105224452d_ekes
deles65139252d_eles
demes86032692d_emes
dene56643412d_ene_
denies74729642d_enies
dens55945072d_en_s
dense65923502d_ense
dents65031802d_ents
dexes135224512d_exes
dices86434242di_ces
didies84621832didies
didoes85716962didoes
dies55653522di__es
diesel74410402diesel
diesels8429142diesels
diesis74013492diesis
dieted83115492dieted
dieter73516772dieter
dieters83216432dieters
diets66026642die_ts
dikes105831332di_kes
dimes85833042di_mes
dimness1038842dimness
dine55555332di_ne_
dined76431992di_ned
diner65632902di_ner
diners75525952diners
dinges83825422dinges
dings76331402di_ngs
dinks105927952di_nks
dinned84317612dinned
dinner74217162dinner
dinners83915442dinners
dinos65428062di_nos
dins56652042di_n_s
dints67431312di_nts
diodes83915782diodes
dipnet91317472dipnet
dipnets10109032dipnets
direness9311302direness
dirges84915102dirges
dishes104622652dishes
dismes95617672dismes
disses75225962disses
dites66339152di_tes
ditzes163212422ditzes
dives95832402di_ves
divines113514722divines
dizened18267332dizened
dizens164911392dizen_s
donees74519492donees
drees65628522dre_es
drones75023432drones
duendes938192duendes
dueness82310122dueness
dunes65332172d_unes
dwines105013102dwines
dynes95917582d_ynes
fiends104110292fiends
fines86644262fi_nes
genes65133092_genes
kines95039132ki_nes
lenes54738522_lenes
lianes63819322lianes
lieges74113442lieges
liens56525502lien_s
liernes739622liernes
lines57054572li_nes
miens76118302mien_s
mines75651952mi_nes
nenes55329672_nenes
nieces84112712nieces
nieves94311292nieves
nines55937342ni_nes
penes75839222_penes
pieces104217272pieces
pinenes93416672pinenes
pines76048862pi_nes
scenes84520352scenes
seines65029902seines
sieges73816832sieges
sieves93216002sieves
sines55954822si_nes
skenes104616632skenes
tines54848422ti_nes
trienes74118412trienes
vines85137642vi_nes
wiener94513542wiener
wieners103212482wieners
wienies102213682wienies
wines85546862wi_nes
zines145232652zi_nes

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511052.15638289.0
3Display Results1051050.0303500.0
 (SQL Overall)1786911052.52970656.8
 
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.