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

183 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
tally8452686(None) 
ally76935641_ally
bally105530101bally
dally95324741dally
gally95026171gally
pally105727121pally
rally84725901rally
sally85129711sally
talky126215681talky
tall47240211tall_
talls55133431talls
telly84920821telly
wally114625091wally
ably99725132_ably
agly86821802_agly
alky115920342_alky
all36148232_all_
allay85620392_allay
alley85721672_alley
alloy85519972_alloy
alls46740922_alls
allyl85310542_allyl
anally9513502anally
badly114918762badly
baldly12479832baldly
baldy115518932baldy
balky145418242balky
ball66043322ball_
balls76236412balls
ballsy11508872ballsy
balmy125217472balmy
belly104625492belly
billy105525362billy
bully105124812bully
call66838672call_
calla74827072calla
calls75634732calls
calmly1337612calmly
chally144314292chally
colly104926772colly
cully105520462cully
daily95922332daily
delly96023872delly
dilly94923782dilly
dolly96125202dolly
dually103210062dually
dully94921632dully
early85324122early
fall75535312fall_
falls85727652falls
fatally1339892fatally
fatly115716802fatly
felly114922802felly
filly114424902filly
folly115022602folly
fully114820862fully
gaily95020972gaily
gall56335992gall_
galley104215452galley
galls64729322galls
gayly124513092gayly
gilly94321632gilly
golly95121102golly
gully94020682gully
hall75741162hall_
hallo85127552hallo
halls85633782halls
haply135915062haply
hilly114422162hilly
holly114824432holly
illy76925332_illy
jelly154218252jelly
jolly154517512jolly
kelly124617022kelly
lall45531312lall_
lalls55324132lalls
laxly15610102laxly
leally94012612leally
lolly85120662lolly
madly115218132madly
mall64639372mall_
malls76233432malls
malmy124816342malmy
malty106721702malty
manly105022952manly
marly106925612marly
molly105222492molly
nelly84618812nelly
orally93113592orally
otalgy1035352otalgy
ovally12278442ovally
palely11311932palely
pall65039342pall_
palls74332562palls
palmy126016732palmy
palsy105417462palsy
paly95835532pa_ly
patly105020582patly
rallye95110162rallye
rawly115115832rawly
really93315612really
retally10413682retally
sadly94519122sadly
sall44544682sall_
salty85524382salty
silly84527622silly
stably113314122stably
stalely1039212stalely
stalky13499302stalky
stall54722352stall_
stalls64019932stalls
stilly93714092stilly
sully84622902sully
tabby125213892tabby
tabla73318362tabla
table75429602table
tacky145617442tacky
tael46030712tael_
taels56822072taels
taffy145110822taffy
tail45443652tail_
taille63116922taille
tails55634192tails
tala45938052ta_la
talar56225382talar
talas55935892talas
talc66226812ta_lc
talcky15294722talcky
talcs74817182talcs
tale46154162ta_le
taler56034872taler
tales55451372tales
tali46837162ta_li
talk86230092ta_lk
talks94322692talks
tallboy1265142tallboy
taller63721962taller
tallis63319962tallis
tallit63422732tallit
tallol63612222tallol
tallow93714202tallow
tallowy13347632tallowy
tallyho1343042tallyho
talon55824112talon
taluk94812872taluk
talus55423262talus
tamely113711952tamely
tammy124013222tammy
tangly104413932tangly
tangy94519952tangy
tansy84514942tansy
tardy94720462tardy
tarry85422512tarry
tartly96014022tartly
tarty86328182tarty
tasty84820312tasty
tatty84720182tatty
tautly9499502tautly
tawny114713652tawny
tell44934702tell_
tells55828942tells
tellys9348842tellys
thalli958922thalli
tidally1137932tidally
till45941212till_
tills54631712tills
toll45535262toll_
tolls54728432tolls
tolyl84710092tolyl
tonally10311372tonally
totally1039892totally
trolly94012362trolly
truly84111552truly
tulle54019932tulle
valley124311602valley
vitally1339672vitally
wall76236102wall_
walla85321032walla
walls85529382walls
waly105830902wa_ly
wanly115118022wanly
welly114620012welly
willy115321912willy

Search took 3 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.340525561.8
2DLD Change Limit538001832.55021098.0
3Display Results1831830.0603050.0
 (SQL Overall)1786911832.95060573.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.