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

105 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
slalomed113428(None) 
slalomer1045031slalomer
sallowed12149032sallowed
slalom888172slalom__
slalomers1144552slalomers
slaloms9106542slalom_s
slammed123511102sla_mmed
alarmed1037733ala_rmed
alarumed1143313alarumed
allowed111610083al_lowed
alloyed11158033al_loyed
balloted1189043balloted
blamed116017953bla__med
blazoned2044313blazoned
bloomed12439433bl_oomed
calmed114816383_cal_med
calomel1138073_calomel
caromed123713623_caromed
claimed12298833cla_imed
clammed14369963cla_mmed
clamored1336943clamored
dialoged1146693dialoged
escaloped1443983escaloped
fallowed15127753fallowed
flamed124618973fla__med
flammed15377413fla_mmed
flavored1554573flavored
galloped12107143galloped
galoped11138073_galoped
gloomed11337413gl_oomed
halloaed121510153halloaed
halloed113314913hallo_ed
hallooed12168773hallooed
hallowed15179493hallowed
haloed104717603_halo_ed
illumed10285863il_lumed
labored102810243_labored
lalled74218753_lal_led
lamed85235293_la__med
lammed113915623_la_mmed
loomed94616763_l_oomed
palmed114314643_pal_med
psalmed1234503psal_med
salaamed1134623salaamed
sallied83316953s_allied
sallower11139503sallower
salted74121203s_al_ted
saluted84511713s_aluted
salved103916423s_al_ved
salvoed11307063s_alvoed
samoyed1335893s_amoyed
savored1158343s_avored
scalded11409763scal_ded
scaled94822443scal__ed
scalloped1444463scalloped
scalped124411993scal_ped
scammed14479543sca_mmed
sealed74328363seal__ed
seamed94823883sea__med
seasoned948113seasoned
shadowed1644473shadowed
shaled105023953shal__ed
shallowed1655083shallowed
shalom11810923shalom__
shaloms1288983shalom_s
shamed125120213sha__med
shammed153911423sha_mmed
shamoyed1744043shamoyed
sialoid8310963sialo_id
siloed74615303s_ilo_ed
slabbed12409503sla_bbed
slacked143815453sla_cked
slagged104312773sla_gged
slaked114318273sla__ked
slaloming1244743slaloming
slalomist1174953slalomist
slammer113913033sla_mmer
slanged94112853sla_nged
slanted83514743sla_nted
slapped123511843sla_pped
slashed114114853sla_shed
slated75028313sla__ted
slatted84015183sla_tted
slaved104017043sla__ved
slavered12188033slavered
slayed104716223sla__yed
slimed94915123s__limed
slimmed12368473sl_immed
sloped94216853s__loped
slowed104617073s__lowed
slummed12359273sl_ummed
soloed74515743s_olo_ed
spalled103113133spal_led
spammed14348523spa_mmed
spasmed12296993spa_smed
staled74728103stal__ed
stalked123811173stal_ked
stalled83515693stal_led
sublimed1337213sublimed
swallowed1663583swallowed
swarmed1367483swa_rmed
tallowed12157713tallowed
taloned8310223_taloned
walloped14146833walloped
wallowed15148163wallowed

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.453394461.4
2DLD Change Limit1461621056.76621602.4
3Display Results1051050.0631666.7
 (SQL Overall)1786911057.28224538.7
 
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.