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

168 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
rally8472590(None) 
ally76935641_ally
bally105530101bally
dally95324741dally
gally95026171gally
orally93113591orally
pally105727121pally
rallye95110161rallye
rawly115115831rawly
really93315611really
sally85129711sally
tally84526861tally
wally114625091wally
ably99725132_ably
agly86821802_agly
alky115920342_alky
all36148232_all_
allay85620392_allay
alley85721672_alley
alloy85519972_alloy
alls46740922_alls
allyl85310542_allyl
anally9513502anally
areally10411242areally
aurally10310542aurally
badly114918762badly
baldly12479832baldly
baldy115518932baldy
balky145418242balky
ball66043322ball_
balls76236412balls
ballsy11508872ballsy
balmy125217472balmy
belly104625492belly
billy105525362billy
brawly144312352brawly
brolly114510852brolly
bully105124812bully
call66838672call_
calla74827072calla
calls75634732calls
calmly1337612calmly
chally144314292chally
colly104926772colly
crawly144610762crawly
cully105520462cully
daily95922332daily
delly96023872delly
dilly94923782dilly
dolly96125202dolly
drably123511612drably
drawly134910722drawly
drolly105411672drolly
dually103210062dually
dully94921632dully
early85324122early
fall75535312fall_
falls85727652falls
fatly115716802fatly
felly114922802felly
filly114424902filly
folly115022602folly
frailly1337312frailly
frilly124111442frilly
fully114820862fully
gaily95020972gaily
gall56335992gall_
galley104215452galley
galls64729322galls
gayly124513092gayly
gilly94321632gilly
golly95121102golly
grayly13287962grayly
gully94020682gully
gyrally1435582gyrally
hall75741162hall_
hallo85127552hallo
halls85633782halls
haply135915062haply
hilly114422162hilly
holly114824432holly
illy76925332_illy
jelly154218252jelly
jolly154517512jolly
jurally1736962jurally
kelly124617022kelly
lall45531312lall_
lalls55324132lalls
laxly15610102laxly
leally94012612leally
lolly85120662lolly
madly115218132madly
mall64639372mall_
malls76233432malls
malmy124816342malmy
malty106721702malty
manly105022952manly
marly106925612marly
molly105222492molly
morally12411492morally
nelly84618812nelly
ovally12278442ovally
palely11311932palely
pall65039342pall_
palls74332562palls
palmy126016732palmy
palsy105417462palsy
paly95835532pa_ly
patly105020582patly
racily11715172racily
racy95825682ra_cy
raggy106116572raggy
rail46147762rail_
rails55937402rails
rainy85921082rainy
rale45050562ra_le
rales54947492rales
rallyes10348552rallyes
ralph1078742ralph
rammy124312492rammy
randy95022082randy
rangy95320392rangy
rankly133910452rankly
raptly11338912raptly
rarely93513652rarely
rashly123410212rashly
raspy106511702raspy
rattly94111542rattly
ratty84819592ratty
ravelly13268352ravelly
ray66361992ra__y
realty92713692realty
redly94217202redly
refly113914562refly
regally1159872regally
relay84424672relay
rely75428952r_ely
reply104015852reply
retally10413682retally
riley84420582riley
rill45140902rill_
rille55728732rille
rills55032712rills
roily86121112roily
roll46331652roll_
rolls55326232rolls
royally13157732royally
ruly76323142r_uly
rurally1038302rurally
sadly94519122sadly
sall44544682sall_
salty85524382salty
silly84527622silly
sully84622902sully
talky126215682talky
tall47240212tall_
talls55133432talls
telly84920822telly
trolly94012362trolly
valley124311602valley
virally1339652virally
wall76236102wall_
walla85321032walla
walls85529382walls
waly105830902wa_ly
wanly115118022wanly
welly114620012welly
willy115321912willy

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 Filter178691538000.296603685.8
2DLD Change Limit538001681.47036598.6
3Display Results1681680.0632666.7
 (SQL Overall)1786911681.82997698.7
 
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.