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

490 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
dialler84881(None) 
dialer74315431dia_ler
dialled9510131dialled
diallel845681diallel
diallers957771diallers
baller83825202_baller
biller84923482bi_ller
caller85125482_caller
dalles74222062d_alles
dallier84215372d_allier
dealer74122142dea_ler
diablery1443232diablery
dialed84716452dia_led
dialers83614302dia_lers
dialoger1056082dialoger
dialyser1243692dialyser
dialyzer2143112dialyzer
diaper94513112dia_per
diaster82813312diaster
dibbler124510282dibbler
diddler103511512diddler
dilater83515652dilater
dilled84122222di_lled
disabler1147912disabler
drawler11338592drawler
driller84311882driller
droller84110282droller
dueller8329832dueller
duller74017702d_uller
dweller11297272dweller
faller94621232_faller
filler94623622fi_ller
giller74519732gi_ller
hiller94421632hi_ller
iller54821292_i_ller
killer104917952ki_ller
miller84625412mi_ller
siller64026062si_ller
smaller93410332smaller
spaller92713472spaller
taller63721962_taller
tiller64222542ti_ller
vialled1156842vialled
willer94021062wi_ller
abler75624313__abler
alder65421913__alder
allee54932123__allee
alley85721673__alley
alter54828503__alter
bailer85425253_bailer
balder95318863_balder
baler75635273_ba_ler
balker124519163_balker
balled94926893_balled
ballers94421013_ballers
ballet84733973_ballet
bawler114315053_bawler
bialies93618413bialies
bilayer12347803bilayer
bilker124913443bi_lker
billed94224903bi_lled
billers94720833bi_llers
billet86029723bi_llet
birler85715083bi_rler
brailler1036883brailler
brawler124310233brawler
cabler104519173_cabler
calker124917083_calker
called94126733_called
callee84327293_callee
callers94221963_callers
callet84536763_callet
calmer105216933_calmer
canaller1038953canaller
chiller124112183chiller
circler1136423circler
coaler84121713coa_ler
coalier93416183coalier
cradler102910513cradler
crawler123510453crawler
cruller968753cruller
culler84322253_culler
dabber114816963d_abber
dabbler124012153dabbler
dacker134920753d_acker
dafter104813343d_after
dagger95017303d_agger
daiker115113033d_aiker
dailies84219263dailies
dale55643983d_a_le_
dales66439743d_a_les
dallied93713613d_allied
dalliers93610613d_alliers
dallies84023193d_allies
dally95324743d_all_y
dammer114317933d_ammer
damner95213433d_amner
damper114117753d_amper
dancer94817613d_ancer
dander811222993d_ander
dandler94414273dandler
danger83722823d_anger
dangler96912813dangler
danker114319663d_anker
dapper114016633d_apper
darer65230793d_a_rer
darker114718693d_arker
darner74017303d_arner
darter75320363d_arter
dasher104318983d_asher
dater65332313d_a_ter
dauber94112013d_auber
dawdler12356793dawdler
dazzler1634713dazzler
deader84220473dea_der
deadlier1036863deadlier
deafer104114813dea_fer
dealers84118613dea_lers
dearer74822803dea_rer
defiler113911883defiler
delayer113010533delayer
delver104913493d_elver
desalter938363desalter
detailer9268673detailer
diablerie1243583diablerie
diadem1037583dia_dem
dial55935063dia_l__
dialect101210263dialect
dialing94318173dialing
dialist8517763dialist
diallage1045233diallage
diallages1145463diallages
dialling10310783dialling
diallist949553diallist
dialog837973dia_log
dialoged1146693dialoged
dialogers1155163dialogers
dialogs938103dialogs
dialoguer1143163dialoguer
dials64925343dia_l_s
dialyse1135463dialyse
dialysed1344413dialysed
dialysers1343163dialysers
dialyses1236133dialyses
dialyze2044433dialyze
dialyzed2243733dialyzed
dialyzers2242783dialyzers
dialyzes2144503dialyzes
diameter1148053diameter
diapers104713913dia_pers
diapir9357113dia_pir
diaries83321953diaries
diastem10318043diastem
diasters92913183diasters
diazole1736793diazole_
diazoles1836323diazoles
dibber114614713di_bber
dibble114013843dibble_
dibbled133510843dibbled
dibblers13377583dibblers
dibbles124013333dibbles
dicer85426423di__cer
dicier94416233di_cier
dicker134521403di_cker
dickier143512453dickier
dictier103411863dictier
didapper1442953didapper
diddle94915213diddle_
diddled114212053diddled
diddlers11359153diddlers
diddles103915073diddles
diddley13388103diddley
diester83013683diester
dieter73516773di_eter
diether1147443diether
differ133910843di_ffer
digger94616083di_gger
diker105524553di__ker
dilate73220693dilate_
dilated93115823dilated
dilaters92513063dilaters
dilates83220663dilates
dilator82712783dilator
dill55239973di_ll__
dillies84122163dillies
dills65530973di_ll_s
dilly94923783di_ll_y
diluter8319663diluter
dimer85625603di__mer
dimeter10411893dimeter
dimmer114112613di_mmer
dimple113512793dimple_
dimpled132810303dimpled
dimples122813213dimples
dimplier1336673dimplier
dindle84417223dindle_
dindled104412723dindled
dindles93817243dindles
diner65632903di__ner
dinger85323673di_nger
dingier93513673dingier
dingle84317073dingle_
dingles93818323dingles
dinkier123411503dinkier
dinner74217163di_nner
diopter1038473diopter
diplex16408053di_plex
diplexer1844203diplexer
diploe9810153diploe_
diploes101111493diploes
dipolar1056853dipolar
dipole91112853dipole_
dipoles101013753dipoles
dipper114017793di_pper
dippier123111393dippier
direr64927073di__rer
dirled84514903di_rled
dirtier83312093dirtier
disable10516433disable_
disabled1248713disabled
disablers1255803disablers
disables11410903disables
disallow1243513disallow
disarmer1138033disarmer
disaster949943disaster
dishier113613403dishier
disliker13358643disliker
dismaler1137903dismaler
dispeller12146973dispeller
distiller1046663distiller
ditcher134012003ditcher
dither104417683di_ther
ditsier83010293ditsier
ditzier17307963ditzier
diver94827803di__ver
divider12278953divider
diviner11369883diviner
divulger1342553divulger
dizzier16317543dizzier
doable93115243doable_
dollar74110983d_ollar
dolled83518073d_olled
doodler93310153doodler
doubler103110083doubler
drabber12438593drabber
drafter11449423drafter
dragger10309173dragger
drainer83012843drainer
draper94315693dra_per
drawer104711363dra_wer
drawled12368343drawled
drawlers12307313drawlers
drawlier12225253drawlier
dribbler13316313dribbler
drilled94711673drilled
drillers9429723drillers
driveler1284693driveler
driveller1353853driveller
drolled93810223drolled
drollery12314793drollery
dually103210063duall_y
dueler74213683d_ueler
duelled9359753duelled
duellers9268223duellers
dulled84719423d_ulled
dwarfer1433683dwarfer
dwelled12337593dwelled
dwellers12356083dwellers
dyable12308983dyable_
enabler9299363enabler
eviller1056673eviller
exalter1437563exalter
fabler116115813_fabler
faille93414743faille_
failles102914133failles
fallen93813373_fallen
fallers103917993_fallers
falser93912413_falser
falter94519053_falter
feller94419553_feller
fickler16348423fickler
fiddler12309953fiddler
fielder11217413fielder
filer85433003fi__ler
fille84327403fi_lle_
filled104922263fi_lled
fillers104320213fi_llers
filles94224523fi_lles
fillet95027083fi_llet
filmer114112403fi_lmer
filter94517633fi_lter
finagler12194953finagler
frailer10319943frailer
friller104111743friller
fueller10279963fueller
fuller94220383_fuller
galled84622863_galled
gallery11468743_gallery
gallet73630853_gallet
galley104215453_galley
gaoler73913573_gaoler
giggler101029883giggler
gilder84415533gi_lder
gilled84521633gi_lled
gillers84216903gi_llers
girdler9227313girdler
girlier8289523girlier
griller84513353griller
hailer94720343_hailer
haler85033523_ha_ler
hallel93514093_hallel
halter94420883_halter
hauler95015123_hauler
healer94221803hea_ler
heller93322513_heller
higgler12369803higgler
hilled104022223hi_lled
hillers103718733hi_llers
hillier103413963hillier
holler93520613_holler
huller93919103_huller
idler65015663_i_dler
inlier63615363_inlier
jailer134316683_jailer
jilter133512513ji_lter
jingler154311093jingler
killed113918773ki_lled
killers114215583ki_llers
kilter103714343ki_lter
kindler12309983kindler
kittler11338163kittler
knoller11285903knoller
kruller1145153kruller
ladler74314933_ladler
lalled74218753_lalled
liable81415813liable_
libeler9219003libeler
libeller10297433libeller
littler7348553littler
loller63315283_loller
luller63415483_luller
mailer84724183_mailer
malled94626113_malled
mallee84525593_mallee
mallei84414633_mallei
mallet84433053_mallet
mauler84416713_mauler
mealier93015903mealier
miauled1036663miauled
mickler153310233mickler
middler112712273middler
milder93818453mi_lder
miler75733063mi__ler
milker124814323mi_lker
mille75029133mi_lle_
milled94326173mi_lled
millers93621343mi_llers
milles84526563mi_lles
millet84030743mi_llet
millier93716703millier
milter84921233mi_lter
mingler104213843mingler
misalter1038343misalter
miscaller1346283miscaller
muller83820353_muller
nailer64119363_nailer
nibbler11379273nibbler
niggler93610293niggler
nilled73919453ni_lled
nimbler11358063nimbler
oiler54628283oi__ler
oilier64417233oi_lier
paler75436933_pa_ler
palier85023563_palier
palled94625163_palled
pallet84232653_pallet
pallier94417163_pallier
pallor8313673_pallor
palmer105816543_palmer
palter84423263_palter
pearler9310373pearler
pedaller1136093pedaller
piaffer15104443piaffer
piaster93012883piaster
piddler112911523piddler
pilfer1139163pi_lfer
pillar8314023pi_llar
pilled94222753pi_lled
poller83921853_poller
psalter9247813psalter
puller83820813_puller
queller16289293queller
railer64524933_railer
raillery1134953raillery
rallier73816273_rallier
realer63528593rea_ler
realter73716313realter
recaller1039323recaller
redialled1145883redialled
riddler93411263riddler
riffler13328353riffler
rifler94014263ri_fler
rille55728733ri_lle_
rilled74525653ri_lled
rilles64725503ri_lles
rillet64828853ri_llet
rippler113210103rippler
rivalled1236093rivalled
roller63919793_roller
sailer63526103_sailer
sallet63734543_sallet
sallier73320423_sallier
salter64325083_salter
salver94617753_salver
scaler84321603sca_ler
scalier94316913scalier
scalper113912923scalper
sculler99812153sculler
sealer63928963sea_ler
seller63824593_seller
shalier103116423shalier
sheller103515883sheller
sidler74716963si_dler
signaller1043693signaller
sillers73822103si_llers
sillier74017593sillier
silver93815813si_lver
simpler112910863simpler
sizzler15266863sizzler
smeller94212783smeller
snarler73610633snarler
sneller73512843sneller
spalled103113123spalled
spallers102910733spallers
speller95415143speller
spiller92914333spiller
squaller1736083squaller
stabler94014933stabler
staler64025823sta_ler
stalker113912253stalker
stalled83515683stalled
stapler93913633stapler
stiller73414293stiller
sweller103012463sweller
swiller103211663swiller
tailer63823733_tailer
taille63116923taille_
tailles72516473tailles
tailleur843303tailleur
taler56034863_ta_ler
talker103916223_talker
tallier72817213_tallier
teller63519813_teller
thaler94613103tha_ler
tickler133612653tickler
tiddler93110003tiddler
tiler56131023ti__ler
tilled74722953ti_lled
tillers73418743ti_llers
tilter63417693ti_lter
tingler83613343tingler
tinkler113610543tinkler
tippler11348343tippler
toller63819443_toller
trailer73015393trailer
trawler104011903trawler
triller74215893triller
troller73913173troller
valley124311603_valley
valuer93911443_valuer
vealer94016543vea_ler
vealier102712173vealier
viable111613773viable_
vialed105112593via_led
viler86324163vi__ler
wailer93720323_wailer
waler84229263_wa_ler
walker133913993_walker
walled104021293_walled
wallet93327093_wallet
whaler124611973wha_ler
wielder11197673wielder
wiggler123110763wiggler
wilder103616473wi_lder
wilier93217073wi_lier
willed104722453wi_lled
willers103517913wi_llers
willet95124833wi_llet
yeller94214513_yeller
yielder11175113yielder

Search took 9 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.1561145455.1
2DLD Change Limit1340274907.78317220.5
3Display Results4904900.1702882.4
 (SQL Overall)1786914908.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.