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 “wawls” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

159 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
wawls11541647(None) 
awls75926091_awls
bawls105719321bawls
pawls105617661pawls
wails86631481wails
walls85529381walls
wauls86120551wauls
wawl105321941wawl_
waws106834901waw_s
yawls114613601yawls
aals49941142_aals
ails45654712_ails
alls46740922_alls
als36663022_a_ls
awes76037552_awes
awl67635302_awl_
awns75324432_awns
awols84713522awols
baals76122702baals
bails75933522bails
balls76236412balls
bals66354042ba_ls
bawds116115492bawds
bawl95326062bawl_
bowls106121432bowls
brawls115214332brawls
calls75634732calls
carls77037422carls
cauls75727772cauls
caws96036102caw_s
cowls106922212cowls
crawls114712082crawls
dahls95012282dahls
dals57145122da_ls
dawks135213492dawks
dawns95916592dawns
daws86638242daw_s
dawts97216122dawts
drawls105511392drawls
earls56127512earls
fails85631482fails
falls85727652falls
farls85731112farls
fawns115914262fawns
fowls115518892fowls
galls64729322galls
gals57946502ga_ls
gaols66717572gaols
gawks136811632gawks
gawps115911012gawps
hails85231642hails
halls85633782halls
harls85634502harls
hauls86123732hauls
hawks155415702hawks
haws106439442haw_s
howls116219222howls
jails125422942jails
jarls126120962jarls
jaws145027292jaw_s
jowls156214522jowls
kails95525212kails
lalls55324132lalls
lawns85215422lawns
laws76441682law_s
mails76037772mails
malls76233432malls
marls75535162marls
mauls76524952mauls
maws96437132maw_s
mewls105813232mewls
nails55730402nails
owls76022932_owls
pails75833062pails
palls74332562palls
pals66951352pa_ls
pawl95123262pawl_
pawns108818132pawns
paws96038182paw_s
rails55937402rails
rawly115115832rawly
raws75238212raw_s
sails55738102sails
sals46851672sa_ls
sauls55128122sauls
saws75839482saw_s
shawls125411972shawls
swails94913122swails
taels56822072taels
tails55634192tails
talls55133432talls
taws75641592taw_s
trawls94412392trawls
vails85825932vails
vaws105527322vaw_s
wabs97337232wa_bs
wacks146626282wacks
wades95634142wades
wadis95223962wadis
wads87343142wa_ds
waes76048602wa_es
waffs146315472waffs
wafts116920552wafts
wages95330932wages
wags86140552wa_gs
waifs115719872waifs
wail75238822wail_
wains86930862wains
wairs86424062wairs
waits88333522waits
wakes126633652wakes
wale74546432wa_le
wales86142832wales
walk115625612wa_lk
walks126218502walks
wall76236102wa_ll
walla85321032walla
wallas95719392wallas
wally114625092wally
waly105830902wa_ly
wames106432802wames
wamus105514682wamus
wands96425482wands
wanes85040882wanes
wanks126124482wanks
wanly115118022wanly
wans76452262wa_ns
wants87932212wants
waps96642082wa_ps
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802wa_rs
warts814840402warts
was68767562wa__s
wasps106714692wasps
wasts87433672wasts
wats77555882wa_ts
watts86923092watts
wauks125515162wauks
waul76927312waul_
waves115633922waves
waw97046382waw__
wawled133811702wawled
waxes155825502waxes
ways107737952wa_ys
weals85428742weals
wells85426192wells
wills84528962wills
wools84421462wools
wows104633492wow_s
yawl104918972yawl_
yawns114213272yawns
yawps13628792yawps
yaws105531212yaw_s
yowls115715432yowls

Search took 4 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 Filter178691538000.1261418182.5
2DLD Change Limit538001592.78019352.5
3Display Results1591590.0931709.7
 (SQL Overall)1786911592.99959583.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.