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

373 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
diallers95777(None) 
dialers83614301dia_lers
dialler848811dialler_
ballers94421012_ballers
billers94720832bi_llers
callers94221962_callers
dalles74222062d_alle_s
dalliers93610612d_alliers
dealers84118612dea_lers
diablery1443232diablery
dialer74315432dia_ler_
dialled9510132dialle_d
diallel845682dialle_l
dialogers1155162dialogers
dialysers1343162dialysers
dialyzers2242782dialyzers
diapers104713912dia_pers
diasters92913182diasters
dibblers13377582dibblers
diddlers11359152diddlers
dilaters92513062dilaters
disablers1255802disablers
drawlers12307312drawlers
drillers9429722drillers
duellers9268222duellers
dwellers12356082dwellers
fallers103917992_fallers
fillers104320212fi_llers
gillers84216902gi_llers
hillers103718732hi_llers
killers114215582ki_llers
millers93621342mi_llers
sillers73822102si_llers
spallers102910732spallers
tillers73418742ti_llers
willers103517912wi_llers
alders74218423__alders
allees64521483__allees
alleys95113303__alleys
alters64924223__alters
bailers94221353_bailers
balers85626933_ba_lers
balkers134915723_balkers
baller83825203_baller_
ballets93719513_ballets
bawlers124412733_bawlers
bialies93618413bialie_s
bilayers13296923bilayers
bilkers134711863bi_lkers
biller84923483bi_ller_
billets94516153bi_llets
birlers93813003bi_rlers
braillers1135553braillers
brawlers13408643brawlers
cablers114416713_cablers
calkers134414693_calkers
callees94117783_callees
caller85125483_caller_
callets93821703_callets
canallers1137213canallers
chillers133710923chillers
circlers1235353circlers
coalers94419353coa_lers
coalless1038193coalless
cradlers11309203cradlers
crawlers13309013crawlers
crullers1047303crullers
cullers93418853_cullers
dabbers123813213d_abbers
dabblers13379363dabblers
dackers143417043d_ackers
daggers103714913d_aggers
daikers124010313d_aikers
dailies84219263dailie_s
dales66439743d_a_le_s
dallier84215373d_allier_
dallies84023193d_allies
dammers123214273d_ammers
damners104112113d_amners
dampers123915693d_ampers
dancers103413093d_ancers
danders93921183d_anders
dandlers103912053dandlers
dangers94818213d_angers
danglers103610593danglers
darers75921873d_a_rers
darners83815773d_arners
darters84017603d_arters
dashers115016863d_ashers
daters74827373d_a_ters
daubers104610423d_aubers
dawdlers13375673dawdlers
dazzlers1733233dazzlers
dealer74122143dea_ler_
defilers12439473defilers
delayers12268663delayers
delvers113411993d_elvers
desalters1037673desalters
detailers10257253detailers
diablerie1243583diablerie
diableries1344603diableries
diadems1135393dia_dems
dialect101210263dia_lect
dialects11126003dialects
dialed84716453dia_le_d
dialings10329823dialings
dialists9411413dialists
diallage1045233diallage
diallages1145463diallages
dialling10310783dialling
diallings1134993diallings
diallist949553diallist
diallists1056003diallists
dialoger1056083dialoger_
dialogs938103dia_logs
dialoguers1242213dialoguers
dials64925343dia_l__s
dialyser1243693dialyser_
dialyses1236133dialyses
dialysis1245413dialysis
dialyzer2143113dialyzer_
dialyzes2144503dialyzes
diameters1247603diameters
diaper94513113dia_per_
diapirs10347643dia_pirs
diaries83321953diarie_s
diastems11226523diastems
diaster82813313diaster_
diazoles1836323diazole_s
dibbers124013173di_bbers
dibbler124510283dibbler_
dibbles124013333dibble_s
dicers94720743di__cers
dickers144117663di_ckers
didappers1543173didappers
diddler103511513diddler_
diddles103915073diddle_s
diddleys14334633diddleys
diesters92513603diesters
dieters83216433di_eters
diethers1257453diethers
differs14339973di_ffers
diggers104413393di_ggers
dikers114418793di__kers
dilater83515653dilater_
dilates83220663dilate_s
dilators93213203dilators
dilled84122223di_lle_d
dillies84122163di_llies
dills65530973di_ll__s
diluters9288113diluters
dimers94321093di__mers
dimeters11411093dimeters
dimmers123811563di_mmers
dimples122813213dimple_s
dindles93817243dindle_s
diners75525953di__ners
dingers94321383di_ngers
dingles93818323dingle_s
dinners83915443di_nners
diopters1137693diopters
diplexers1943573diplexers
diploes101111493diploe_s
dipoles101013753dipole_s
dippers123615183di_ppers
disabler1147913disabler_
disables11410903disable_s
disallows1343393disallows
disarmers1246943disarmers
disasters1039153disasters
dislikers14286423dislikers
dispellers13115453dispellers
distillers1145133distillers
ditchers143610363ditchers
dithers114016153di_thers
divers105024963di__vers
dividers13257213dividers
diviners12308353diviners
divulgers1442433divulgers
dollars83311023d_ollars
doodlers10338843doodlers
doublers11288503doublers
drafters12338533drafters
draggers11357393draggers
drainers92811253drainers
drapers105313353dra_pers
drawers113610073dra_wers
drawler11338593drawler_
dribblers14274453dribblers
driller84311883driller_
drivelers1364223drivelers
drivellers1452953drivellers
droller84110283droller_
drollery12314793drollery
duelers83412053d_uelers
dueller8329833dueller_
duller74017703d_uller_
dweller11297273dweller_
enablers10196913enablers
exalters1536653exalters
fablers124812613_fablers
failles102914133faille_s
faller94621233_faller_
falters103916473_falters
fellers104117543_fellers
fiddlers13328283fiddlers
fielders12156773fielders
filers94623723fi__lers
filler94623623fi_ller_
filles94224523fi_lle_s
fillets103414753fi_llets
filmers124211293fi_lmers
filters103816553fi_lters
finaglers13173893finaglers
frillers11349873frillers
fuellers11277983fuellers
fullers103817373_fullers
gallery11468743_gallery
gallets83517403_gallets
galleys11369713_galleys
gaolers83511563_gaolers
gigglers11297403gigglers
gilders94212463gi_lders
giller74519733gi_ller_
girdlers10195403girdlers
goalless935723goalless
grillers93810813grillers
hailers104017263_hailers
halers94926913_ha_lers
hallels103310133_hallels
halters104619803_halters
halvers133311423_halvers
haulers104012443_haulers
healers104319463hea_lers
hellers103619833_hellers
higglers13297233higglers
hiller94421633hi_ller_
hollers103818233_hollers
hullers103616263_hullers
idealless1042953idealless
idlers74012813_i_dlers
iller54821293_i_ller_
inliers73110743_inliers
jailers144114043_jailers
jilters144211963ji_lters
jinglers16408763jinglers
killer104917953ki_ller_
kilters113813603ki_lters
kindlers13318483kindlers
knollers12255143knollers
krullers1234133krullers
ladlers84613573_ladlers
libelers10238623libelers
libellers11236033libellers
lollers72713793_lollers
lullers73213353_lullers
mailers94420333_mailers
mailless10248583mailless
mallees93315973_mallees
mallets93318493_mallets
malleus92911313_malleus
maulers94213303_maulers
mealless10288363mealless
middlers123410193middlers
milers84625163mi__lers
milkers134411613mi_lkers
miller84625413mi_ller_
milles84526563mi_lle_s
millets94216843mi_llets
milliers102611903milliers
milters93619093mi_lters
minglers113011293minglers
misalters1136913misalters
miscallers1444303miscallers
mullers93217303_mullers
nailers73215893_nailers
nibblers12306543nibblers
nigglers10307253nigglers
oilers64721193oi__lers
pallets93919303_pallets
pallors9314363_pallors
palmers113513623_palmers
palters94021683_palters
pearlers1039033pearlers
pedallers1244763pedallers
piaffers16114203piaffers
piasters102912813piasters
piddlers12359593piddlers
pilfers1238963pi_lfers
pillars9313493pi_llars
pollers93420023_pollers
psalters10227713psalters
pullers93618483_pullers
quellers17237533quellers
railers74420663_railers
raillery1134953raillery
ralliers84010833_ralliers
realters83614043realters
recallers1137103recallers
riddlers10269103riddlers
rifflers14336443rifflers
riflers103512193ri_flers
rilles64725503ri_lle_s
rillets74216153ri_llets
ripplers12337113ripplers
rollers73117473_rollers
sailers73822323_sailers
sailless82410373sailless
sallets73719653_sallets
salliers83613343_salliers
salters73622253_salters
salvers103916003_salvers
scalers93817263sca_lers
scalpers123710863scalpers
scullers103510483scullers
sealers74323553sea_lers
sellers73721323_sellers
shellers112812583shellers
sidlers83414233si_dlers
signallers1142843signallers
siller64026063si_ller_
silvers104714043si_lvers
sizzlers16274753sizzlers
smaller93410333smaller_
smellers10329773smellers
snarlers8298753snarlers
spaller92713473spaller_
spellers102812763spellers
spillers103311703spillers
squallers1834683squallers
stablers103611153stablers
stalkers12369853stalkers
staplers103111203staplers
swillers11299113swillers
tailers73720183_tailers
tailles72516473taille_s
tailless8239083tailless
tailleurs942803tailleurs
talers64628143_ta_lers
talkers113513213_talkers
taller63721963_taller_
talliers83711373_talliers
tellers73717603_tellers
thalers106212263tha_lers
ticklers14339303ticklers
tiddlers10288653tiddlers
tilers63523503ti__lers
tiller64222543ti_ller_
tilters73315953ti_lters
tinglers93710593tinglers
tinklers12298183tinklers
tipplers12336353tipplers
tollers73217463_tollers
trailers82912923trailers
trawlers113310203trawlers
trillers83613493trillers
trollers83211213trollers
valleys13407483_valleys
valuers10328943_valuers
vealers103214293vea_lers
vialled1156843vialle_d
wailers103916803_wailers
walers94824463_wa_lers
walkers143411473_walkers
wallets103914833_wallets
whalers13529703wha_lers
wielders12196613wielders
wigglers13257213wigglers
wilders113513503wi_lders
willer94021063wi_ller_
willets104414323wi_llets
yellers103912953_yellers
yielders12164743yielders

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461623737.01620832.7
3Display Results3733730.1402664.3
 (SQL Overall)1786913737.57923577.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.