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

186 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
diallel84568(None) 
dialled9510131dialled
dialler848811dialler
dalles74222062d_alles
dialed84716452dia_led
dialer74315432dia_ler
diallers957772diallers
dilled84122222di_lled
hallel93514092_hallel
vialled1156842vialled
allee54932123__allee
allele64514563__allele
alley85721673__alley
allyl85310543__allyl
balled94926893_balled
baller83825203_baller
ballet84733973_ballet
bialies93618413bialies
billed94224903bi_lled
biller84923483bi_ller
billet86029723bi_llet
called94126733_called
callee84327293_callee
caller85125483_caller
callet84536763_callet
dailies84219263dailies
dale55643983d_a_le_
dales66439743d_a_les
dallied93713613d_allied
dallier84215373d_allier
dallies84023193d_allies
dally95324743d_all_y
damsel9148033d_amsel
darnel74312183d_arnel
dealer74122143dea_ler
diablery1443233diablery
diadem1037583dia_dem
dial55935063dia___l
dialect101210263dialect
dialers83614303dialers
dialing94318173dialing
dialist8517763dialist
diallage1045233diallage
diallages1145463diallages
dialling10310783dialling
diallist949553diallist
dialog837973dia_log
dialoged1146693dialoged
dialoger1056083dialoger
dialogs938103dialogs
dials64925343dia_l_s
dialyse1135463dialyse
dialysed1344413dialysed
dialyser1243693dialyser
dialyses1236133dialyses
dialyze2044433dialyze
dialyzed2243733dialyzed
dialyzer2143113dialyzer
dialyzes2144503dialyzes
diaper94513113dia_per
diaries83321953diaries
diastem10318043diastem
diaster82813313diaster
diazole1736793diazole_
diazoles1836323diazoles
dibble114013843dibble_
dibbled133510843dibbled
dibbler124510283dibbler
dibbles124013333dibbles
diddle94915213diddle_
diddled114212053diddled
diddler103511513diddler
diddles103915073diddles
diddley13388103diddley
diel59034603di___el
diesel74410403di_esel
dilate73220693dilate_
dilated93115823dilated
dilater83515653dilater
dilates83220663dilates
dill55239973di__l_l
dillies84122163dillies
dills65530973di_ll_s
dilly94923783di_ll_y
dimple113512793dimple_
dimpled132810303dimpled
dimples122813213dimples
dindle84417223dindle_
dindled104412723dindled
dindles93817243dindles
dingle84317073dingle_
dingles93818323dingles
diplex16408053di_plex
diploe9810153diploe_
diploes101111493diploes
dipole91112853dipole_
dipoles101013753dipoles
dirled84514903di_rled
disable10516433disable_
disabled1248713disabled
disabler1147913disabler
disables11410903disables
disallow1243513disallow
dispel9310323di_spel
doable93115243doable_
dolled83518073d_olled
drawled12368343drawled
drawler11338593drawler
drilled94711673drilled
driller84311883driller
drolled93810223drolled
droller84110283droller
dually103210063duall_y
duelled9359753duelled
dueller8329833dueller
dulled84719423d_ulled
duller74017703d_uller
dwelled12337593dwelled
dweller11297273dweller
dyable12308983dyable_
faille93414743faille_
failles102914133failles
fallal93612693_fallal
fallen93813373_fallen
faller94621233_faller
fille84327403fi_lle_
filled104922263fi_lled
filler94623623fi_ller
filles94224523fi_lles
fillet95027083fi_llet
galled84622863_galled
gallet73630853_gallet
galley104215453_galley
gilled84521633gi_lled
giller74519733gi_ller
hallal94415563_hallal
hallels103310133_hallels
hilled104022223hi_lled
hiller94421633hi_ller
iller54821293_i_ller
killed113918773ki_lled
killer104917953ki_ller
lalled74218753_lalled
liable81415813liable_
malled94626113_malled
mallee84525593_mallee
mallei84414633_mallei
mallet84433053_mallet
miauled1036663miauled
mille75029133mi_lle_
milled94326173mi_lled
miller84625413mi_ller
milles84526563mi_lles
millet84030743mi_llet
nilled73919453ni_lled
palled94625163_palled
pallet84232653_pallet
parallel1047473parallel
pilled94222753pi_lled
redialled1145883redialled
rille55728733ri_lle_
rilled74525653ri_lled
rilles64725503ri_lles
rillet64828853ri_llet
rivalled1236093rivalled
sallet63734543_sallet
scalpel11377713scalpel
siller64026063si_ller
smaller93410333smaller
spalled103113133spalled
spaller92713473spaller
stalled83515683stalled
taille63116923taille_
tailles72516473tailles
taller63721963_taller
tallol63612223_tallol
tilled74722953ti_lled
tiller64222543ti_ller
valley124311603_valley
viable111613773viable_
vialed105112593via_led
walled104021293_walled
wallet93327093_wallet
willed104722453wi_lled
willer94021063wi_ller
willet95124833wi_llet

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271866.40620922.1
3Display Results1861860.0762447.4
 (SQL Overall)1786911866.91825829.9
 
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.