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

453 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
diplex1640805(None) 
duplex16386971duplex
biflex1834952biflex
dialed84716452dialed
dialer74315432dialer
dilled84122222dilled
dimple113512792dimple_
dimpled132810302dimpled
dimples122813212dimples
diplexer1844212diplexer
diploe9810152diploe
diploes101111492diploes
dipnet91317472dipnet
dipole91112852dipole_
dipoles101013752dipoles
dipped123517492dipped
dipper114017792dipper
dirled84514902dirled
duple85315862duple_
ilex115822032_i_lex
plex137321372__plex
silex123417412si_lex
simplex18256392simplex
triplex16447802triplex
aiglet74224193aiglet
ailed66240283ai_led
aisle55223193aisle_
aisled74516183aisled
aisles64721143aisles
ample94720303ample_
ampler104313303ampler
apex137220213_ap_ex
apple94517673apple_
apples104315763apples
applet105917433applet
bible95119423bible_
bibles104617643bibles
bile66147183bi_le_
biles75542143bi_les
billed94224903billed
biller84923483biller
billet86029723billet
biped104718833bip_ed
birle75023633birle_
birled94416993birled
birler85715083birler
birles84920643birles
caplet104226813caplet
cimex16119133ci_mex
cipher133710263cipher
complex2037243complex
culex144613933_culex
dale55643983d_ale_
dales66439743d_ales
dalles74222063dalles
dapped124516763dapped
dapper114016633dapper
dapple1138853dapple_
dappled1336393dappled
dapples1238993dapples
dealer74122143dealer
deflea1037443deflea
dele56843083d_ele_
deled75326543d_eled
deles65139253d_eles
deplete103010423deplete
deploy1237583deploy
desex13311983d_esex
dex116936883d___ex
dhole95215363dhole_
dholes104914793dholes
diadem1037583diadem
dial55935063dial__
dialect101210263dialect
dialers83614303dialers
dialled9510133dialled
diallel845683diallel
dialler848813dialler
dialog837973dialog
dials64925343dial_s
diaper94513113diaper
dibbed124713473dibbed
dibber114614713dibber
dibble114013843dibble_
dibbled133510843dibbled
dibbler124510283dibbler
dibbles124013333dibbles
dice75841893di_ce_
diced95824683di_ced
dicer85426423di_cer
dices86434243di_ces
dicey114819333di_cey
dicier94416233dicier
dicked144920863dicked
dicker134521403dicker
dickey165913523dickey
diddle94915213diddle_
diddled114212053diddled
diddler103511513diddler
diddles103915073diddles
diddley13388103diddley
didie74120563didie_
didies84621833didies
didoes85716963didoes
die46759653di__e_
died66137853di__ed
diel59034603di__el
diene65720133diene_
dienes75719903dienes
dies55653523di__es
diesel74410403diesel
dieses75218693dieses
diet57357533di__et
dieted83115493dieted
dieter73516773dieter
differ133910843differ
digged104314653digged
digger94616083digger
diglot83014333diglot
dike95935763di_ke_
diked115024683di_ked
diker105524553di_ker
dikes105831333di_kes
dikey135116423di_key
dildo71911773di_ldo
dill55239973di_l_l
dillies84122163dillies
dills65530973di_lls
dilly94923783di_lly
dime76237643di_me_
dimer85625603di_mer
dimes85833043di_mes
dimly114913483diml_y
dimmed124110323dimmed
dimmer114112613dimmer
dimplier1336673dimplier
dimply14339743dimpl_y
dindle84417223dindle_
dindled104412723dindled
dindles93817243dindles
dine55555333di_ne_
dined76431993di_ned
diner65632903di_ner
dines66449153di_nes
dinge75627303dinge_
dinged95221783dinged
dinger85323673dinger
dinges83825423dinges
dingey114914053dingey
dingle84317073dingle_
dingles93818323dingles
dinked124818353dinked
dinkey144812763dinkey
dinned84317613dinned
dinner74217163dinner
dinted84419843dinted
diode74716113diode_
diodes83915783diodes
diol57329133diol__
diols65521013diol_s
diopter1038473diopter
dip67848983dip___
diplegia1244053diplegia
diplegic1444793diplegic
diplexers1943573diplexers
diploic1247763diploic
diploid11310293diploid
diploma1295933diploma
diplont10311693diplont
diploses111110323diploses
dipnets10109033dipnets
dipody1336363dipody
dipolar1056853dipolar
dippers123615183dippers
dippier123111393dippier
dippy135111543dip_py
dips75536913dip__s
dipsas9359893dipsas
dipso85111553dip_so
dipsos95310053dipsos
dipt77339323dip__t
diptera1037213diptera
dire56644143di_re_
direly10311563direly
direr64927073di_rer
dirge75117073dirge_
dirges84915103dirges
dirked124912273dirked
dirl57430023dirl__
dirls64720503dirl_s
disced104914653disced
dished114318713dished
dishes104622653dishes
disked125015763disked
disme85716243disme_
dismes95617673dismes
dispel9310323dispel
dispels10310503dispels
display1336663display
dissed85220183dissed
disses75225963disses
dite55547553di_te_
dites66339153di_tes
dither104417683dither
ditzes163212423ditzes
dive85634773di_ve_
dived106321373di_ved
diver94827803di_ver
dives95832403di_ves
dizen155214933di_zen
dogleg936323dogleg
doiled84817293doiled
dole56550003d_ole_
doled75430913d_oled
doles67843753d_oles
dolled83518073dolled
doolee73018953doolee
dope76038893dop_e_
doped95326713dop_ed
doper86128393dop_er
dopes84935043dop_es
dopey116020353dop_ey
dopier93515923dopier
doyley13487283doyley
driblet103712243driblet
drilled94711673drilled
driller84311883driller
dripless1135243dripless
dripped13408083dripped
dripper12349233dripper
droplet10312113droplet
dueled84813663dueled
dueler74213683dueler
dulled84719423dulled
duller74017703duller
dupe76630603dup_e_
duped95118323dup_ed
duper85519003dup_er
dupes86425933dup_es
duplexed1943143duplexed
duplexer1842903duplexer
duplexes1844053duplexes
dupped124411643dupped
edible969353edible_
edibles1048003edibles
edile64819493edi_le_
ediles74016983edi_les
file75446643fi_le_
filed95331903fi_led
filer85433003fi_ler
files85441273fi_les
filet85540163fi_let
fille84327403fille_
filled104922263filled
filler94623623filler
filles94224523filles
fillet95027083fillet
fipple13329063fipple_
fipples14298653fipples
flex146123473__flex
funplex1932833funplex
giblet93418893giblet
giglet83920273giglet
gilled84521633gilled
giller74519733giller
gimlet93716663gimlet
gipped124815903gipped
gipper114215303gipper
hilled104022223hilled
hiller94421633hiller
hipless12399923hipless
hiply134113613hipl_y
hipped144317693hipped
hipper133818023hipper
hirple11158973hirple_
hirpled13157143hirpled
hirples12149643hirples
ibex133813483_i_bex
idle55423763_idle_
idled74915213_idled
idler65015663_idler
idles66720123_idles
ilea45931463_i_lea
iller54821293_iller
impled113812513impled
index13310983_index
inlet53732403_inlet
isle45121703_isle_
isled64615993_isled
isles54220563_isles
islet54527553_islet
killed113918773killed
killer104917953killer
kipped153114573kipped
kippen14299013kippen
kipper143414213kipper
lex107943823___lex
lipe66839733lip_e_
lipless9259553lipless
lipped114419543lipped
lippen103911403lippen
lipper104219633lipper
lisle53916723lisle_
lisles63416283lisles
maple95521143maple_
maples104819423maples
midleg1038553midleg
mile66352573mi_le_
miler75733063mi_ler
miles74645073mi_les
mille75029133mille_
milled94326173milled
miller84625413miller
milles84526563milles
millet84030743millet
mirex146816623mi_rex
misled94719313misled
mispled12310463mispled
nilled73919453nilled
nipped113615853nipped
nipper103715713nipper
nipple103410373nipple_
nippled12307643nippled
nipples11319663nipples
oiled64429473oi_led
oiler54628283oi_ler
perplex1836153perplex
piglet93420923piglet
pile65649693pi_le_
pilea75123953pi_lea
piled85232993pi_led
pilei74021783pi_lei
piles74742613pi_les
pilled94222753pilled
pimple123512963pimple_
pimpled14289193pimpled
pimples133012423pimples
piolet83225643piolet
pipe86434433pip_e_
piped105123163pip_ed
piper96523193pip_er
pipes96030143pip_es
pipet95533323pip_et
pipier104913983pipier
pipped104516543pipped
plea66830603__plea
pleb86123813__pleb
pled75231433__pled
plew97222813__plew
pollex153711163pollex
prex135722973__prex
reflex16359513reflex
repled93319783repled
riblet84222443riblet
ridley10169543ridley
rifle85518333rifle_
rifled104115003rifled
rifler94014263rifler
rifles94217703rifles
rile45650533ri_le_
riled65833253ri_led
riles55343643ri_les
riley84420583ri_ley
rille55728733rille_
rilled74525653rilled
rilles64725503rilles
rillet64828853rillet
rimple103814583rimple_
rimpled123311423rimpled
rimples113114223rimples
ripe66038923rip_e_
riped85226433rip_ed
ripely112511153ripely
ripen75619263rip_en
riper74328403rip_er
ripes75435773rip_es
ripped114419013ripped
ripper103518653ripper
ripple103413913ripple_
rippled123110273rippled
rippler113210103rippler
ripples113513293ripples
ripplet113412583ripplet
scolex1538243scolex
sidle65124033sidle_
sidled84215173sidled
sidler74716963sidler
sidles74721153sidles
siller64026063siller
silvex16336723silvex
simple104315173simple_
simpler112910863simpler
simples113014943simples
sipe67341043sip_e_
siped84927683sip_ed
sipes76036953sip_es
sipped113720633sipped
sipper103920993sipper
sippet103519393sippet
spile75230083spile_
spiled94621993spiled
spiles84227913spiles
swiple11379233swiple_
swiples12339643swiples
telex125214823_telex
tile45451443ti_le_
tiled64832943ti_led
tiler56131023ti_ler
tiles55542103ti_les
tilled74722953tilled
tiller64222543tiller
tipless92610063tipless
tipped114418263tipped
tipper103918413tipper
tippet103917873tippet
tipple103411913tipple_
tippled12358393tippled
tippler11348343tippler
tipples112811253tipples
tirled74714363tirled
title54721073title_
titled73815003titled
titles63719923titles
triple84215923triple_
tripled104113833tripled
triples94616873triples
triplet94319213triplet
vialed105112593vialed
vile76139803vi_le_
viler86324163vi_ler
violet92620923violet
viper105017303vip_er
wiglet105519153wiglet
wile75944373wi_le_
wiled95231553wi_led
wiles85437873wi_les
willed104722453willed
willer94021063willer
willet95124833willet
wimple133611363wimple_
wimpled15338823wimpled
wimples143311173wimples
wipe94830283wip_e_
wiped114722083wip_ed
wiper105421293wip_er
wipes104827083wip_es
yipe96722183yip_e_
yipes106017843yip_es
yipped143613283yipped
yippee132810743yippee
zipless18276303zipless
zipped203612983zipped
zipper193813123zipper

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127164535.04622337.7
3Display Results4534530.1433167.8
 (SQL Overall)1786914535.56232127.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.