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

182 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
wadmals133551(None) 
wadmaals1442411wadmaals
wadmal1237281wadmal_
wadmels1334301wadmels
wadmols1333911wadmols
admass957142_admass
hamals114816822ha_mals
hammals14409222hammals
mammals10389272mammals
radials83614632radials
tamals84116632ta_mals
wadmaal1343202wadmaal
wadmel1235522wadmel_
wadmol1234052wadmol_
wadmoll1352902wadmoll
wadmolls1442572wadmolls
aals49941143_a__als
adman84517903_adma_n
admirals1144353_admirals
admits9411413_admits
agmas85919873_agma_s
almahs118611613_almahs
almas76629773_alma_s
amahs107819063_a_mahs
amas67746293_a_ma_s
amass77119683_a_mass
amyls104512693_a_myls
animals94111703animals
annals66415923_annals
appals104812943_appals
argals75517713_argals
atmans84413963_atmans
atmas75721013_atma_s
baals76122703ba__als
badass949293bad_ass
badman113813843badma_n
bromals1139743bromals
cabals104020153ca_bals
caimans113811783caimans
camails11311753ca_mails
camas96333523ca_ma_s
camass104114183ca_mass
camels105217083ca_mels
canals84421663ca_nals
cantals93919573cantals
carpals113414623carpals
casuals91410523casuals
causals91411183causals
caymans14349513caymans
dadas75819863dad_a_s
dals57145123__d_als
damans94715983da_mans
damars93814993da_mars
dammars12308193dammars
deals65435343__deals
dhals95415443__dhals
dials64925343__dials
dismals102010243dismals
duals65620083__duals
facials123310743facials
fallals103310193fallals
farfals13268503farfals
faucals12326563faucals
formals123312893formals
gadwall1244563gadwall
gadwalls1343873gadwalls
gamas85431363ga_ma_s
gamays126310913ga_mays
gammas115714693gamma_s
gavials1136603gavials
gayals1039513ga_yals
gimmals12225823gimmals
graduals1046203graduals
hadal95518123had_al_
haemal113811643haemal_
halals95018313ha_lals
halmas117017893halma_s
hamal104623113ha_mal_
hamauls12387813ha_mauls
hammal134512063hammal_
hammams13386443hammams
hartals10313023hartals
hazmats2136603hazmats
ideals75012503_ideals
jacals1539873ja_cals
jackals2036893jackals
kamala12339963ka_mala
kamalas13339123ka_malas
karmas123013733karma_s
labials9299873labials
lamas75532793la_ma_s
landmass1144423landmass
madames12310063madames
madams11310943mad_ams
madcaps1435243madcaps
madman113712383madma_n
madras94316433madra_s
magmas115512503magma_s
mamas95930773ma_ma_s
mammal95112753mammal_
mammas94616403mamma_s
manuals9311213manuals
maximals19325223maximals
medals94218053med_als
medials103914733medials
modals93914453mod_als
nadas66320813nad_a_s
narwals1036983narwals
nasals63312463na_sals
normals92510903normals
oatmeals1043843oatmeals
ordeals877993ordeals
padnags1135083padnags
parrals94414573parrals
pascals11610013pascals
pedals94316033ped_als
radars71314673rad_ars
radial74020393radial_
radiale83813523radiale
radians83013823radians
radicals112610153radicals
radulas839583radulas
ramal74622243ra_mal_
rascals959663rascals
ratals64219583ra_tals
redials84416883redials
sabals84618863sa_bals
sacrals93311793sacrals
salals65120083sa_lals
sambals115213483sambals
sandals82715203sandals
tamal73522623ta_mal_
tamale83717403ta_male
tamales93216153ta_males
tarmacs1138323tarmacs
tarsals72512603tarsals
vandals113211663vandals
vassals1057953vassals
wadable13310233wadable
wadders123812443wadders
waddies124214753waddies
waddle114715303wad_dle
waddles124314843waddles
waddly14478723wad_dly
wadeable1437443wadeable
waders109120643wad_ers
wades95634143wad__es
wadies105121203wad_ies
wadis95223963wad__is
wads87343143wad___s
wadsets1136443wadsets
wagtails1244443wagtails
wails86631483wa__ils
wakames1635283wakames
wallahs13409473wallahs
wallas95719393walla_s
walls85529383wa__lls
wamble134415753wa_mble
wambles143714023wa_mbles
wambly16388663wa_mbly
wames106432803wa_m_es
wammus13426733wa_mmus
wampus13499013wa_mpus
wamus105514683wa_m_us
wangans1149503wangans
warmers124514293warmers
warmly14228063warm_ly
warms107726853warm__s
warmths1583783warmths
warmups1433813warmups
warsaws1335763warsaws
wassails1145953wassails
wataps11248683wa_taps
wauls86120553wa__uls
wawls115416473wa__wls
waylays1634673waylays
weals85428743w__eals
wedels103811033wed_els
wheals124512523w_heals
womans114613653w_omans
wormils1236733wormils
yasmaks1633653yasmaks

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.500357382.0
2DLD Change Limit1340271825.76623244.4
3Display Results1821820.0632888.9
 (SQL Overall)1786911826.32928233.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.