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

286 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
wadmal123728(None) 
wadmaal1343201wadmaal
wadmals1335511wadmals
wadmel1235521wadmel
wadmol1234051wadmol
adman84517902_adman
badman113813842badman
hadal95518122had_al
haemal113811642haemal
hamal104623102ha_mal
hammal134512062hammal
madman113712382madman
mammal95112752mammal
radial74020392radial
ramal74622242ra_mal
tamal73522612ta_mal
wadmaals1442412wadmaals
wadmels1334302wadmels
wadmoll1352902wadmoll
wadmols1333912wadmols
aal39058673_a__al
addax1435993_addax
admass957143_admass
admen84516183_admen
admiral1046363_admiral
admit8319493_admit
admix1557723_admix
agma77623263_agma_
agmas85919873_agmas
aidman92410623aidman
algal66518213_algal
alma66333023_alma_
almah106917253_almah
almas76629773_almas
ama510853303_a_ma_
amah98927483_a_mah
amas67746293_a_mas
amyl95515093_a_myl
anal48037523_a_nal
animal85016253animal
annal56520763_annal
appal95315223_appal
areal55928733_areal
argal65023383_argal
artal55525473_artal
arval86017013_arval
atma68121773_atma_
atman75520143_atman
atmas75721013_atmas
audial7312993audial
aural54428963_aural
axal116520493_a_xal
axial124515193_axial
axman144813183_axman
baal67033113ba__al
badmen114613833badmen
bagman114613813bagman
banal75925993ba_nal
barbal104016663barbal
barman103519703barman
basal75722283ba_sal
batman105214063batman
bayman133712703bayman
beadman12249153beadman
bromal10313653bromal
brumal1049503brumal
cabal95222153ca_bal
cabman123812503cabman
cadmic1338973cadmic
caecal103713733caecal
caiman103615663caiman
camail10314823ca_mail
camas96333523ca_mas
camel96822803ca_mel
canal75428043ca_nal
cantal84122033cantal
carman103920743carman
carnal83919203carnal
carpal103716253carpal
casual81112863casual
caudal91611483caudal
causal81413203causal
cayman133613213cayman
chasmal14158213chasmal
comal95125133_comal
dada66422443dad_a_
dadas75819863dad_as
daedal849083daedal
dal47554953__d_al
daman84821163da_man
damar84117733da_mar
dammar11438903dammar
deadman11238423deadman
deal56347413__deal
dedal75719023ded_al
dermal93614343dermal
dhal86719283__dhal
dial55935063__dial
dismal92412243dismal
domal85619203_domal
dual55928173__dual
facial113615633facial
faecal11359813faecal
fallal93612693fallal
farfal123410183farfal
fatal84819373fa_tal
faucal11339963faucal
faunal94711593faunal
formal113215203formal
gadwall1244563gadwall
gagman103811243gagman
gama77035513ga_ma_
gamas85431353ga_mas
gamay116419103ga_may
gamma106116103gamma_
gammas115714693gammas
gasman92911743gasman
gavial10310083gavial
gayal9312713ga_yal
gimmal11247513gimmal
gradual936943gradual
halal85623593ha_lal
hallal94415563hallal
halma108219253halma_
halmas117017893halmas
hamals114816813ha_mals
hamaul114210863ha_maul
hammals14409213hammals
hammam12419333hammam
hartal9415473hartal
hazmat20312263hazmat
headman13229633headman
hemal104419803_hemal
hiemal11339493hiemal
ideal65716393_ideal
jacal14313703ja_cal
jackal1937613jackal
kamala12339963ka_mala
karma113415003karma_
karmas123013733karmas
labial84714343labial
laical8312323laical
lama66635293la_ma_
lamas75532793la_mas
landman1038923landman
larval948503larval
lawman11289053lawman
layman113511303layman
leadman10237843leadman
madam10316223mad_am
madame1139853madame
madams11310943madams
madcap1336333madcap
madmen113511743madmen
madras94316423madras
magma104513573magma_
magmas115512503magmas
mama86231583ma_ma_
mamas95930773ma_mas
mamma86317913mamma_
mammae94613213mammae
mammals10389273mammals
mammas94616403mammas
manual8313463manual
maximal18347093maximal
medal86221323med_al
medial93819863medial
miasmal1176743miasmal
modal85919233mod_al
nada58022903nad_a_
nadas66320813nad_as
nadiral836343nadiral
narial6317953narial
narwal938943narwal
nasal56217593na_sal
nasial6413283nasial
natal53921493na_tal
naval85315833na_val
nidal65217103nid_al
nodal64717793nod_al
normal83213533normal
oatmeal944973oatmeal
ordeal779253ordeal
padnag1036073padnag
paleal84716673paleal
palmar104113463palmar
palpal104112053palpal
papal95820673pa_pal
parral85517533parral
pascal10812373pascal
pausal81511963pausal
pedal86022503ped_al
primal104014623primal
racial83419243racial
radar61316723rad_ar
radiale83813523radiale
radials83614633radials
radian74117273radian
radical103312793radical
radula749313radula
ragman94013713ragman
rascal8511123rascal
ratal55025113ra_tal
redial74923113redial
rodman949713rodman
sabal75422483sa_bal
sacral83414413sacral
salal55425703sa_lal
sambal105215183sambal
sandal73317283sandal
sandman10310173sandman
stomal85213313stomal
swagman1334913swagman
tamale83717393ta_male
tamals84116623ta_mals
tarmac10310333tarmac
tarnal63716503tarnal
tarsal63315273tarsal
taxman15328613taxman
tidal64516443tid_al
vagal94613633va_gal
valval12398863valval
vandal103713833vandal
vanman1139793vanman
vasal85516293va_sal
vassal979243vassal
wad77053893wad___
wadable13310233wadable
wadded124014173wadded
wadder114215483wadder
waddie114013323waddie
waddle114715303waddle
waddly14478723waddly
waddy135312993wad_dy
wade85237063wad__e
wadeable1437443wadeable
waded106024753wad_ed
wader95325363wad_er
waders109120643waders
wades95634143wad_es
wadi86228173wad__i
wadies105121203wadies
wading114619533wading
wadis95223963wad_is
wadmolls1442573wadmolls
wads87343143wad__s
wadset10314303wadset
wady115324993wad__y
waeful1238123waeful
wagtail1145043wagtail
wail75238823wa__il
wakame1535433wakame
wall76236103wa__ll
walla85321033walla_
wallah124011993wallah
wallas95719393wallas
wamble134415753wa_mble
wambly16388663wa_mbly
wame95035483wa_m_e
wames106432803wa_mes
wammus13426733wammus
wamus105514683wa_mus
wangan10311223wangan
warm95935673warm__
warmed124516893warmed
warmer113816733warmer
warmly14228063warmly
warms107726853warm_s
warmth1477933warmth
warmup1335343warmup
warsaw1236193warsaw
wassail1056133wassail
watap102111673wa_tap
waul76927313wa__ul
wawl105321943wa__wl
waylay1535453waylay
weal75838683w__eal
wedel94513953wed_el
wheal115716183w_heal
withal1238933withal
woadwax2142163woadwax
woman105818003w_oman
woodman1336313woodman
wormil1138043wormil
yardman1335913yardman
yasmak1534593yasmak

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162865.57620214.5
3Display Results2862860.1402042.9
 (SQL Overall)1786912865.85930498.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.