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

131 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
allies6382767(None) 
alkies104518091alkies
allees64521481allees
allied74217151allied
ballies93725741ballies
dallies84023191dallies
gallies84122711gallies
rallies73823341rallies
sallies73227811sallies
tallies73624601tallies
wallies103320741wallies
aaliis6312902aaliis
ables75935542abl_es
ablins8316192ablins
aeries64737782aeries
aggies83515512aggies
alates64833962alates
albites9313202albites
alcids94812292alcids
ales47067102a_l_es
algins74816432algins
alias55834602a_lias
alibies9313322alibies
alien56425582a_lien
aliens65619212a_liens
alifs86121262a_lifs
alines65735222alines
alkalies12158542alkalies
alkie95520032alkie_
alkines114415732alkines
allays94313742allays
allee54932122all_ee
alleges84212572alleges
alleles73812032alleles
alley85721672all_ey
alleys95113302alleys
allium8311242allium
alliums957972alliums
allods73615082allods
allots64019172allots
allows94517682allows
alloys94014562alloys
alls46740922all__s
alludes83610332alludes
allures72913112allures
allyls9437272allyls
almes75126542a_lmes
aloes54933672a_loes
aloins65022202aloins
alpines94016192alpines
alsikes1137262alsikes
amies76837692a_mies
aplites9314932aplites
applies11311212applies
arles56735742arl_es
armies85123692armies
axles125219472axl_es
bailies94120202bailies
baldies105317702baldies
belies84631052belies
bellies94023722bellies
billies93923502billies
bullies94121892bullies
callees94117782callees
challies133915642challies
colies84837052colies
collies94326582collies
cullies94419962cullies
dailies84219262dailies
dalles74222062dall_es
dallied93713612dallied
dallier84215372dallier
dalliers93610612dalliers
dellies83622212dellies
dillies84122162dillies
dollies83620982dollies
falsies103515012falsies
fellies104119742fellies
fillies103420252fillies
flies85630712_flies
follies103618942follies
gallied94115002gallied
gillies84120962gillies
gullies84717312gullies
halloes104021522halloes
holies94630032holies
hollies103420812hollies
illites72415012illites
jellies143816532jellies
jollies143516272jollies
kellies113516852kellies
killies113318112killies
ladies75124882ladies
lazies154418782lazies
lies46454192__lies
lilies63021412lilies
lollies73116922lollies
mallees93315972mallees
molies84429512molies
mollies93420232mollies
nellies73418722nellies
oldies7314422oldies
pallier94417162pallier
palliest102814632palliest
palsies94420272palsies
plies74526512_plies
polies84034582polies
rallied83514082rallied
rallier73816272rallier
ralliers84010832ralliers
rallyes10348552rallyes
relies65036422relies
sallied83316952sallied
sallier73320422sallier
salliers83613342salliers
salties73725772salties
sillies73425082sillies
sullies74122232sullies
talkies113415732talkies
tallied83314752tallied
tallier72817212tallier
talliers83711372talliers
tallis63319962talli_s
tallises82713262tallises
tallits73215992tallits
tellies73820502tellies
uglies7412322uglies
walies95324522walies
wallie93216802wallie_
wellies103719072wellies
willies103920152willies

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 Filter178691825510.420425454.8
2DLD Change Limit825511313.11026543.7
3Display Results1311310.0462847.8
 (SQL Overall)1786911313.57649969.5
 
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.