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

180 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
pawls10561766(None) 
awls75926091_awls
bawls105719321bawls
pails75833061pails
palls74332561palls
pals66951351pa_ls
pawl95123261pawl_
pawns108818131pawns
paws96038181paw_s
wawls115416471wawls
yawls114613601yawls
aals49941142_aals
ails45654712_ails
alls46740922_alls
als36663022_a_ls
awes76037552_awes
awl67635302_awl_
awns75324432_awns
awols84713522_awols
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
opals75718352opa_ls
owls76022932_owls
pacas96029402pacas
paces96741112paces
packs135528932packs
pacs85842182pa_cs
pacts95125802pacts
padis86227142padis
padle84522342padle
padles95221112padles
pads76742952pa_ds
pages85235072pages
paiks114719852paiks
pail66141832pail_
pains75138282pains
pairs75325832pairs
pal56761672pa_l_
pale66055012pa_le
pales75753802pales
pall65039342pa_ll
pally105727122pally
palm85331362pa_lm
palms94921752palms
palp85828572pa_lp
palps94719562palps
palsy105417462pa_lsy
paly95835532pa_ly
pams85641762pa_ms
panels84716522panels
panes76148692panes
pangs84628662pangs
pans65855722pa_ns
pants76536922pants
papas94927492papas
paps86443452pa_ps
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parle75836162parle
parles86334392parles
parols84722612parols
parrs75928672parrs
pars67560792pa_rs
parts77743372parts
pas58775742pa__s
pases75346502pases
pass65239952pa_ss
pasts75936502pasts
pates76047892pates
paths105521382paths
patly105020582patly
pats66460852pa_ts
paves104833922paves
pavis106422732pavis
paw87651172paw__
pawed115725612pawed
pawer104422972pawer
pawers114818782pawers
pawky173810152pawky
pawn94625302paw_n
paxes144928422paxes
pays95940222pa_ys
peals75235492peals
pearls84715382pearls
peels75226422peels
pews95731532pew_s
pills74130972pills
polls74627722polls
pols66044562p_ols
pools74427702pools
pows95537662pow_s
prawns11509022prawns
prowls115511082prowls
pulls74425052pulls
puls65437562p_uls
purls74723352purls
rails55937402rails
rawly115115832rawly
raws75238212raw_s
sails55738102sails
sals46851672sa_ls
sauls55128122sauls
saws75839482saw_s
shawls125411972shawls
spails84817822spails
spalls84217342spalls
spawns11577922spawns
sprawls12176372sprawls
taels56822072taels
tails55634192tails
talls55133432talls
taws75641592taw_s
trawls94412392trawls
vails85825932vails
vaws105527322vaw_s
wails86631482wails
walls85529382walls
wauls86120552wauls
wawl105321942wawl_
waws106834902waw_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.1731032896.0
2DLD Change Limit538001803.62314849.6
3Display Results1801800.1431258.7
 (SQL Overall)1786911803.93945364.6
 
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.