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

228 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
ally7693564(None) 
ably99725131ably
agly86821801agly
alky115920341alky
all36148231all_
allay85620391allay
alley85721671alley
alloy85519971alloy
alls46740921alls
allyl85310541allyl
bally105530101bally
dally95324741dally
gally95026171gally
illy76925331illy
pally105727121pally
rally84725901rally
sally85129711sally
tally84526861tally
wally114625091wally
aal39058672aal_
aals49941142aals
able66340532able
aby810238062a_by
achy126316092achy
acyl95314292acyl
aery77231682aery
agley96917332agley
ahoy101919182ahoy
ail37171042ail_
ails45654712ails
airy75734152airy
al210674042a_l_
ala312463602a_la
alae45643752alae
alan46844082alan
alar46340072alar
alary86123442alary
alas46358122alas
alb57342652a_lb
alba68328332alba
albs68628572albs
ale36572342a_le
alec66430062alec
alee46652322alee
alef76340692alef
ales47067102ales
alfa77624272alfa
alga57927602alga
alif76242142alif
alit46155692alit
aliya83713482aliya
alkyd13537092alkyd
alkyl12518042alkyl
allays94313742allays
allee54932122allee
alleys95113302alleys
allod64418382allod
allot54933872allot
allow85420662allow
alloys94014562alloys
allyls9437272allyls
alma66333022alma
alme65832162alme
alms65834922alms
aloe45540192aloe
alow75328592alow
alp56641132a_lp
alps65529242alps
als36663022a_ls
also46423442also
alt36467962a_lt
alto47831262alto
alts46639902alts
alula5317092alula
alum65227612alum
alway116113922alway
amply125012912amply
amyl95515102amyl
anally9513502anally
any68440492a_ny
apply125111392apply
aptly105111812aptly
army96624182army
arty77531312arty
aryl75922342aryl
ashy107717352ashy
auld54125362auld
away108024222away
awl67635302awl_
awls75926092awls
awny105919302awny
awry107619682awry
axle116424602axle
ay511773892a__y
badly114918762badly
baldly12479832baldly
baldy115518932baldy
balky145418242balky
ball66043322ball_
balls76236412balls
ballsy11508872ballsy
balmy125217472balmy
belly104625492belly
billy105525362billy
bully105124812bully
call66838672call_
calla74827072calla
calls75634732calls
calmly1337612calmly
chally144314292chally
clay95927412clay
cloy96623832cloy
colly104926772colly
coly96940532coly
cully105520462cully
daily95922332daily
delly96023872delly
dilly94923782dilly
dolly96125202dolly
dually103210062dually
dully94921632dully
duly85323032duly
early85324122early
eely77725212eely
ell36735682ell_
ells46431352ells
elmy95616792elmy
fall75535312fall_
falls85727652falls
fatly115716802fatly
felly114922802felly
filly114424902filly
flay106332802flay
fley106626852fley
fly97124952_fly
folly115022602folly
fully114820862fully
gaily95020972gaily
gall56335992gall_
galley104215452galley
galls64729322galls
gayly124513092gayly
gilly94321632gilly
gley85724652gley
golly95121102golly
gully94020682gully
hall75741162hall_
hallo85127552hallo
halls85633782halls
haply135915062haply
hilly114422162hilly
holly114824432holly
holy106333432holy
idly85617322idly
ill37437092ill_
ills47030422ills
inly75622212inly
jelly154218252jelly
jolly154517512jolly
kelly124617022kelly
lacy95829632lacy
lady86527152lady
laky116725822laky
lall45531312lall
lalls55324132lalls
laxly15610102laxly
lay68865352_lay
lazy166423072lazy
leally94012612leally
ley66246812_ley
lily76730182lily
lolly85120662lolly
madly115218132madly
mall64639372mall_
malls76233432malls
malmy124816342malmy
malty106721702malty
manly105022952manly
marly106925612marly
molly105222492molly
moly96031912moly
nelly84618812nelly
oily77932252oily
oldy85316842oldy
olla44821172olla
only75319722only
orally93113592orally
ovally12278442ovally
palely11311932palely
pall65039342pall_
palls74332562palls
palmy126016732palmy
palsy105417462palsy
paly95835532paly
patly105020582patly
pily96132732pily
play95928982play
ploy96123602ploy
ply86323552_ply
poly96235152poly
rallye95110162rallye
rawly115115832rawly
really93315612really
rely75428952rely
ruly76323142ruly
sadly94519122sadly
sall44544682sall_
salty85524382salty
silly84527622silly
slay76436382slay
slily85820032slily
sly66228562_sly
slyly11489532slyly
sully84622902sully
talky126215682talky
tall47240212tall_
talls55133432talls
telly84920822telly
ugly86012382ugly
valley124311602valley
wall76236102wall_
walla85321032walla
walls85529382walls
waly105830902waly
wanly115118022wanly
welly114620012welly
willy115321912willy
wily106428812wily

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.263679433.5
2DLD Change Limit298722280.90632971.3
3Display Results2282280.0464956.5
 (SQL Overall)1786912281.215147070.8
 
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.