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

335 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
duplex1638697(None) 
diplex16408051diplex
duple85315861duple_
culex144613932cu_lex
dueled84813662dueled
dueler74213682dueler
dulled84719422dulled
duller74017702duller
dupe76630602dup_e_
duped95118322dup_ed
duper85519002dup_er
dupes86425932dup_es
duplexed1943132duplexed
duplexer1842892duplexer
duplexes1844042duplexes
dupped124411642dupped
funplex1932832funplex
plex137321372__plex
ample94720303ample_
ampler104313303ampler
apex137220213_ap_ex
apple94517673apple_
apples104315763apples
applet105917433applet
auklet104216833auklet
auspex1574793auspex
biflex1834953biflex
bugle84721943bugle_
bugled104918133bugled
bugler94717723bugler
bugles94822443bugles
bulled94626493bulled
bullet84528613bullet
bupkes144811483bupkes
burled94825383burled
burler84723833burler
burley114715753burley
butle75023103butle_
butled94818603butled
butler84220033butler
butles84423913butles
caplet104226813caplet
complex2037243complex
couple104415963couple_
coupled124312673coupled
coupler114713013coupler
couples115317053couples
couplet114717943couplet
culet76040343cu_let
culled94022473culled
culler84322253culler
cullet84727313cullet
cupel9514303cup_el
cupeled1257793cupeled
cupeler1177483cupeler
cupels10310203cupels
cupped134413983cupped
cupper124313863cupper
cupule103410723cupule_
cupules113210263cupules
curled95021653curled
curler85221323curler
curlew114010903curlew
cutler84718033cutler
cutlet84924363cutlet
dale55643983d_ale_
dales66439743d_ales
dalles74222063dalles
dapped124516763dapped
dapper114016633dapper
dapple1138853dapple_
dappled1336393dappled
dapples1238993dapples
dealer74122143dealer
decuple1285363decuple_
decupled1494983decupled
decuples1395283decuples
deflea1037443deflea
dele56843083d_ele_
deled75326543d_eled
deles65139253d_eles
deplete103010413deplete
deploy1237583deploy
desex13311983d_esex
dex116936883d___ex
dhole95215363dhole_
dholes104914793dholes
dialed84716453dialed
dialer74315433dialer
dilled84122223dilled
dimple113512793dimple_
dimpled132810303dimpled
dimples122813213dimples
diplexer1844203diplexer
diploe9810153diploe
diploes101111493diploes
dipnet91317473dipnet
dipole91112853dipole_
dipoles101013753dipoles
dipped123517493dipped
dipper114017793dipper
dirled84514903dirled
dogleg936323dogleg
doiled84817293doiled
dole56550003d_ole_
doled75430913d_oled
doles67843753d_oles
dolled83518073dolled
doolee73018953doolee
dope76038893dop_e_
doped95326713dop_ed
doper86128393dop_er
dopes84935043dop_es
dopey116020353dop_ey
dopier93515923dopier
double94013993double_
doubled11289953doubled
doubler103110083doubler
doubles103113353doubles
doublet103914033doublet
doyley13487283doyley
droplet10312113droplet
drupe85012993drup_e_
drupelet1145663drupelet
drupes94912653drup_es
dual55928173dual__
dually103210063dually
duals65620083dual_s
dubbed124113213dubbed
dubber113814553dubber
duce76933503du_ce_
duces86327473du_ces
ducked144718013ducked
ducker134317993ducker
ducted104012123ducted
dude65629663du_de_
duded84417133du_ded
dudeen857173dudeen
dudes75424373du_des
due45249863du__e_
duel56729703du__el
duelers83412053duelers
duelled9359753duelled
dueller8329833dueller
duelli767003duelli
duello756783duello
duels65619233duel_s
dues56045503du__es
duet56446263du__et
dueted84113593dueted
duffel13407753duffel
duffer134711663duffer
duffle13368533duffle_
duffles14308923duffles
duiker114110593duiker
duke95628103du_ke_
duked115218463du_ked
dukes105023473du_kes
dulcet9314493dulcet
dulia61014983du_lia
dull56430443du_l_l
dullest8312633dullest
dulls64523743du_lls
dully94921633du_lly
dulse65415043du_lse
dulses73913653dulses
duly85323033du_l_y
dumbed124012083dumbed
dumber114414173dumber
dumped123814493dumped
dumper114615213dumper
dumpier12409653dumpier
dunce86319263dunce_
dunces95215753dunces
dune56137583du_ne_
dunes65332173du_nes
dunged95414693dunged
dunked124315283dunked
dunker113616463dunker
dunlin739723dunlin
dunned85015523dunned
dunner73913823dunner
dunted84718503dunted
duolog835803duolog
dup67637883dup___
dupable12238383dupable_
dupers94615603dupers
dupery12378743dupery
duping104113633duping
duplexers1942513duplexers
duplexing2042793duplexing
duplexity2251883duplexity
dups75929513dup__s
dure56341813du_re_
dured75025403du_red
dures65635923du_res
durned84113173durned
dusked124112513dusked
dusted83918373dusted
duster74919723duster
duties74921903duties
duvet9321873du_vet
eupnea835033eupnea
flex146123473__flex
fourplex2042093fourplex
fueled104913603fueled
fueler94313933fueler
fugle94915543fugle_
fugled114813693fugled
fugles104715783fugles
fulled103820653fulled
fuller94220383fuller
furled104717053furled
furler93616403furler
guglet84018223guglet
guile64521133guile_
guiled84315383guiled
guiles73919283guiles
gules64831043gu_les
gulled84521373gulled
gullet74924833gullet
gulley104213163gulley
gulped104610373gulped
gulper93410213gulper
hulled103920013hulled
huller93919103huller
hurled104617453hurled
hurler94717223hurler
hurley125012523hurley
ilex115822033__ilex
impled113812513impled
julep14310533ju_lep
jupe134921003jup_e_
jupes145218553jup_es
lex107943823___lex
lulled74516443lulled
luller63415483luller
lurex124816733lu_rex
maple95521143maple_
maples104819423maples
mule65236973mu_le_
muled85824433mu_led
mules75034293mu_les
muley104819283mu_ley
mulled94721553mulled
mullen83714763mullen
muller83820353muller
mullet84126823mullet
mulley114013453mulley
murex145517173mu_rex
nuclei857723nuclei
nulled74318273nulled
nurled74016233nurled
nutlet64220563nutlet
octuplex1942183octuplex
ouphe104413263ouphe_
ouphes113614633ouphes
outled74020343outled
outlet63728683outlet
perplex1836143perplex
plea66830603__plea
pleb86123813__pleb
pled75231433__pled
plew97222813__plew
pollex153711163pollex
prex135722973__prex
pule65040953pu_le_
puled84926523pu_led
puler74826623pu_ler
pules74538813pu_les
pulled94322193pulled
puller83820813puller
pullet84026333pullet
pulley113713403pulley
pulped114612533pulped
pulper103513273pulper
pupae96515643pupae_
pupped105013273pupped
puppet93514593puppet
purled94520743purled
purple102712673purple_
purpled12299773purpled
purpler11289263purpler
purples112712823purples
pusley11379613pusley
quadplex2742083quadplex
quale143617853quale_
quelea1547303quelea
reflex16359513reflex
repled93319773repled
ruble74521253ruble_
rubles83921703rubles
rule49938423ru_le_
ruled65822523ru_led
ruler54923343ru_ler
rules55234253ru_les
rumple103913013rumple_
rumpled123810013rumpled
rumples113313133rumples
runlet63821413runlet
rupee7321283rup_ee
rupees8312573rupees
scolex1538243scolex
silex123417413_silex
simplex18256393simplex
sublet82827243sublet
sullen62914293sullen
supe65932763sup_e_
super74924483sup_er
supes75628303sup_es
supped114415703supped
supper104115433supper
supple10410203supple_
suppled1248463suppled
suppler1148433suppler
supples11511283supples
sutler63718393sutler
telex125214823_telex
triplex16447803triplex
tule45735873tu_le_
tules54532793tu_les
tulle54019933tulle_
tulles63218893tulles
tupelo836483tupelo
tupped114013233tupped
unled64021073_unled
unlet54133333_unlet
unsex123512633_unsex
upleap10106843_upleap
uplit76020803_uplit
upped103715163_upped
upper93714263_upper
upset73222593_upset
yule75725143yu_le_
yules84521583yu_les

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163355.76619548.4
3Display Results3353350.1103045.5
 (SQL Overall)1786913356.01629702.6
 
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.