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

264 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
lall4553131(None) 
all36148231_all
ball66043321ball
call66838671call
fall75535311fall
gall56335991gall
hall75741161hall
lalls55324131lalls
loll46128381loll
lull44225761lull
mall64639361mall
pall65039341pall
sall44544681sall
tall47240211tall
wall76236101wall
aal39058672_aal
aals49941142aals
ail37171042_ail
al210674042_a_l
ala312463602_ala
alb57342652_alb
ale36572342_ale
alls46740922alls
ally76935642ally
allyl85310542allyl
alp56641132_alp
als36663022_als
alt36467962_alt
awl67635302_awl
baal67033112baal
bail65042802bail
bal56662722ba_l
bald76432902bald
bale66353842bale
balk105132222balk
balls76236412balls
bally105530102bally
balm85534202balm
bals66354042bals
bawl95326062bawl
bell66237182bell
bill67239932bill
boll65634752boll
bull65634872bull
calf96339562calf
calk105527662calk
calla74827072calla
calls75634732calls
calm85032362calm
calo64936442calo
calx135722792calx
carl65144782carl
caul65630002caul
cell65031722cell
cull65929642cull
dahl87019222dahl
dal47554952da_l
dale55643982dale
dally95324742dally
dals57145122dals
dell56938202dell
dill55239972dill
doll56632492doll
dull56430442dull
earl45838142earl
ell36735682_ell
fail74840242fail
falls85727652falls
falx147120782falx
farl76338552farl
fell76833072fell
fill75540192fill
flail85316182flail
full75229152full
gal46055512ga_l
gala55635162gala
gale56347322gale
galls64729322galls
gally95026172gally
gals57946502gals
gaol56925412gaol
gill56336182gill
gull54828452gull
hail74839062hail
halal85623592halal
hale76052832hale
half106238452half
hallo85127552hallo
halls85633782halls
halm95834972halm
halo76437322halo
halt76056302halt
harl75740002harl
haul75530452haul
hell75637892hell
hill76439492hill
hull75428782hull
ill37437092_ill
jail115529092jail
jarl115828132jarl
jell117125872jell
jill116430262jill
kail85131492kail
kale86533752kale
kill85533172kill
la219261632la__
lab58864782la_b
label75019382label
labs67145122labs
lac510155822la_c
lace66848472lace
lack105837682lack
lacs66942482lacs
lacy95829632lacy
lad48165702la_d
lade56345982lade
ladle66320442ladle
lads56549132lads
lady86527152lady
lag47862122la_g
lags56546222lags
laic65931562laic
laid56439142laid
lain46146282lain
lair45934152lair
lake85741602lake
lakh114919952lakh
laky116725822laky
lallan63414172lallan
lalled74218752lalled
lam57666712la_m
lama66635292lama
lamb86832142lamb
lame66849292lame
lamp86233822lamp
lams66552262lams
land56337302land
lane45153322lane
lang56637372lang
lank84734442lank
lap58565272la_p
lapel73716682lapel
laps66848872laps
lar37967532la_r
lard56742002lard
lari45839152lari
lark85733862lark
lars46956572lars
las37281472la_s
lase46148512lase
lash76539652lash
lass47444542lass
last46260322last
lat37593402la_t
late47560482late
lath76640382lath
lati46438272lati
lats45962702lats
latu47934182latu
laud56527722laud
lav66847342la_v
lava76725422lava
lave75642142lave
lavs76734152lavs
law68656642la_w
lawn75925632lawn
laws76441682laws
lax107651522la_x
laxly15610102laxly
lay68865352la_y
lays76043252lays
laze136235052laze
lazy166423072lazy
leal46043272leal
leally94012612leally
lilo46731562lilo
lilt46349942lilt
lily76730182lily
lolls512121732lolls
lolly85120662lolly
lulls54119652lulls
lulu44122882lulu
mail65543432mail
maill74420782maill
male66052292male
malls76233432malls
malm85129972malm
malt66254802malt
marl66341612marl
maul64830712maul
mell64935612mell
mill66541472mill
moll66735702moll
mull65128802mull
nail45838652nail
nala46930392nala
nill45634302nill
null45125312null
pail66141832pail
pal56761672pa_l
pale66055012pale
palls74332562palls
pally105727122pally
palm85331362palm
palp85828572palp
pals66951352pals
paly95835532paly
pawl95123262pawl
pill65339462pill
poll66332132poll
pull64731662pull
rail46147762rail
rale45050562rale
rally84725902rally
rill45140902rill
roll46331652roll
sail45447162sail
sal36462882sa_l
salal55425702salal
sale44959702sale
sally85129712sally
salol55222142salol
salp64534092salp
sals46851672sals
salt45758522salt
saul45836522saul
scall74420372scall
sell45840612sell
shall85024052shall
sill45545152sill
small74016262small
spall74919302spall
stall54722352stall
tael46030712tael
tail45443652tail
tala45938052tala
talc66226812talc
tale46154162tale
tali46837162tali
talk86230092talk
talls55133432talls
tally84526862tally
tell44934702tell
till45941202till
toll45535262toll
vail75432552vail
vale74937342vale
vill75235072vill
wail75238822wail
wale74546432wale
walk115625612walk
walla85321032walla
walls85529382walls
wally114625092wally
waly105830902waly
waul76927312waul
wawl105321942wawl
well75832042well
will75737512will
yald86920602yald
yawl104918972yawl
yell76028322yell
yill75628972yill
zill135727612zill

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298722641.03328917.7
3Display Results2642640.0604400.0
 (SQL Overall)1786912641.169152858.0
 
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.