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

118 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
alamode103816(None) 
alamodes1148021alamodes
alameda1035492alameda
alamo7418142alamo__
alamos8415002alamo_s
almude9399932al_mude
cladode1134612cladode
abalone938903abalone
abode85518813__abode
acnode938203a_cnode
aflame1138723aflam__e
agamete1037403agamete
agamid103710693agamid_
agamids11317013agamids
agamous1037943agamous
agarose838673agarose
alae45643753ala___e
alamedas1145443alamedas
aland65526413ala_nd_
alands75418373ala_nds
alane56135613ala__ne
alanine7316863alanine
alarmed1037743alarmed_
alate55340333ala__te
alated75625153alated_
albacore1243553albacore
albumose1272633albumose
alcade91111513al_cade
alcaide1088453alcaide
alcalde10104953alcalde
alcayde13103723alcayde
alcove1178093al_cove
aldose7311093al_dose
alidade936993alidade
alimony1236013alimony
aliunde835003aliunde
allod64418383al_lod_
allods73615083al_lods
allude73910903al_lude
alme65832163al_m__e
almond91410433al_mond
almonds10127953al_monds
almondy13144483al_mondy
almoner949383al_moner
almost81014433al_most
almuce10348213al_muce
almud84012183al_mud_
almudes10418263al_mudes
almuds9378773al_muds
aloe45540193al__o_e
alone55732963al__one
alumine9412693alumine
alumnae955403alumnae
amarone9311203amarone
amide86128483__amide
amole75724593__amole
anagoge9166643anagoge
anemone9119453anemone
anode65021043__anode
anymore1256243anymore
apagoge11164683apagoge
arame75026623aram__e
aramid93315613aramid_
aramids102810513aramids
blade85923333bla__de
blame95625493blam__e
blamed116017953blamed_
calamine12314033calamine
calamite12312533calamite
chamade15138453chamade
clade85821013cla__de
cladodes1245323cladodes
clammed14369963clammed
clamor1049453clamo_r
clamored1336953clamored
clamorer1236913clamorer
clamors11710093clamors
clamour1196333clamour
clamped144012043clamped
claymore1544263claymore
commode1438123commode
demode104013463_demode
diamide1138473diamide
flambe13489153flam_be
flambee144210013flambee
flame105124443flam__e
flamed124618973flamed_
flammed15377413flammed
flavone1335523flavone
glade75121963gla__de
glamor958193glamo_r
glamors1068123glamors
glamour1065143glamour
halazone2046113halazone
lade56345983_la__de
lambda1146113_lambda
lambed115614783_lambed
lambie103213673_lambie
lame66849293_lam__e
lamed85235293_lamed_
lamedh12476363_lamedh
lameds94812033_lameds
lamiae84817453_lamiae
lammed113915623_lammed
lamped114017543_lamped
lanose6313593_lanose
lode56240113_l__ode
malamute1245893malamute
mode75840303___mode
nialamide1252763nialamide
outmode10199663outmode
palinode1145713palinode
plumose1135963plumose
ramose8314403_ramose
sagamore1144353sagamore
sarode75317513_sarode
slammed123511103slammed
vamose1159283_vamose

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.403443402.0
2DLD Change Limit1340271187.70317399.3
3Display Results1181180.0462565.2
 (SQL Overall)1786911188.15221919.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.