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 “unallied” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

200 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
unallied93839(None) 
allied74217152__allied
dallied93713612_dallied
gallied94115002_gallied
rallied83514082_rallied
sallied83316952_sallied
tallied83314752_tallied
unallayed1344072unallayed
unalleged1144452unalleged
unallowed1344412unallowed
unalloyed1343722unalloyed
unapplied1443742unapplied
uncalled11810922uncall_ed
ungalled1078462ungall_ed
unsullied1044542unsullied
unwalled1288652unwall_ed
allies63827673__allies
analysed12166913analysed
analyzed21155703analyzed
balled94926893_ball_ed
ballies93725743_ballies
bellied104314073_bellied
bullied104514813_bullied
called94126733_call_ed
canalled1139583canall_ed
challie124012853challie_
challies133915643challies
collied103316673_collied
cullied104012353_cullied
dallier84215373_dallier
dallies84023193_dallies
dialled9510133diall_ed
dollied93811143_dollied
enabled102510633enabl_ed
galled84622863_gall_ed
gallies84122713_gallies
gillied95512313_gillied
gnarled9287723gnarl_ed
gnarlier9255163gnarlier
gullied93812063_gullied
halloed113314913_halloed
inwalled1275773inwall_ed
jellied15419223_jellied
jollied15349273_jollied
knelled12338993knell_ed
knolled12296573knoll_ed
lalled74218753_lall_ed
malled94626113_mall_ed
misallied1246543misallied
muralled1136423murall_ed
nailed74021493_nail_ed
naled65525053_na_l_ed
nellie63614813_nellie_
nellies73418723_nellies
nilled73919453_nill_ed
nulled74318273_null_ed
palled94625163_pall_ed
pallid93915283_palli_d
pallier94417163_pallier
palsied102911303_palsied
rallier73816273_rallier
rallies73823343_rallies
retallied1046783retallied
sallier73320423_sallier
sallies73227813_sallies
snailed83811923snail_ed
snarled83612363snarl_ed
snarlier8278183snarlier
snelled83313043snell_ed
spalled103113133spall_ed
stalled83515683stall_ed
sullied83714483_sullied
tallier72817213_tallier
tallies73624603_tallies
trollied935893trollied
unabated11310133unabated
unable83819223unabl_e_
unabused1135623unabused
unacted10312733una_cted
unadded10238523una_dded
unadmired1343863unadmired
unadvised1443283unadvised
unaged83916423una__ged
unagile838283unagile_
unagreed1036823unagreed
unaided92414603una_ided
unaimed102812493una_imed
unaired82916013una_ired
unalarmed1244633unalarmed
unalerted1047963unalerted
unaligned1144873unaligned
unalike11311533una_like
unaltered1037723unaltered
unamazed2035883unamazed
unamused1135793unamused
unaneled939793unaneled
unarched14128553unarched
unargued1035583unargued
unarmed101811923una_rmed
unasked122010023una_sked
unatoned939423unatoned
unattired1045083unattired
unaudited1145853unaudited
unavowed1534783unavowed
unawaked1635903unawaked
unawed103914903una__wed
unaxed144113093una__xed
unbaled103315963unbal_ed
unbelief1346773unbelief
unbelted1179333unbelted
unbilled1188693unbilled
unblamed1337193unblamed
unbodied1237263unbodied
unboiled112410373unboiled
unbolted1179323unbolted
unburied11208513unburied
uncalcined1543713uncalcined
unclaimed1435793unclaimed
unclawed1457983unclawed
unclosed111010503unclosed
uncloyed1487343uncloyed
uncoiled112512683uncoiled
undenied102211563undenied
undried92314613un_dried
undulled1036993undulled
unenvied1244653unenvied
unfallen1144463unfall_en
unfelted1279403unfelted
unfilled1298383unfilled
unfilmed1495803unfilmed
unflawed1536123unflawed
unflexed1935263unflexed
unfluted1237173unfluted
unfoiled12249723unfoiled
unfolded1338313unfolded
ungelded1147403ungelded
unglazed1936263unglazed
ungloved1335603ungloved
unglued937303un_glued
unhailed12219963unhail_ed
unhallowed1742193unhallowed
unhalved1556513unhalved
unharried1344763unharried
unhelmed1435993unhelmed
unhelped1435923unhelped
unholier1137283unholier
unified112413573un_ified
unilobed1136393unilobed
unlaced102913733un_laced
unladed92614373un_laded
unlaid7311753un_lai_d
unlashed12289183unlashed
unled64021073un__l_ed
unlevied1236843unlevied
unliked122411283un_liked
unlined82515803un_lined
unlived112511373un_lived
unlobed10219743un_lobed
unloved112310533un_loved
unmailed11229763unmail_ed
unmanlier1144243unmanlier
unmarried1244583unmarried
unmelted1169183unmelted
unmilled1197853unmilled
unmolded1237453unmolded
unnailed9229443unnail_ed
unoiled82415483unoil_ed
unpiled102312743unpil_ed
unpitied1138793unpitied
unplaced1338613unplaced
unplaited1236883unplaited
unplayed1437263unplayed
unplowed1436353unplowed
unpoliced1445163unpoliced
unpolled1168943unpolled
unrolled9610413unrolled
unruled8311373unrul_ed
unrulier845333unrulier
unsalaried1144033unsalaried
unsalted9510923unsalted
unslaked1338463unslaked
unsliced1138093unsliced
unsoiled92412083unsoiled
unsolid8138373unsoli_d
unsolved1237833unsolved
untidied1038903untidied
untied73720813un__tied
untilled9710563untilled
untilted9610893untilted
untried82615853un_tried
unvalued1266313unvalued
unvaried1239683unvaried
unveiled1298163unveiled
unwelded1337143unwelded
unwilled1277823unwilled
vialled1156843viall_ed
walled104021293_wall_ed
wallie93216803_wallie_
wallies103320743_wallies
willied114611563_willied

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461622006.73321708.3
3Display Results2002000.1261587.3
 (SQL Overall)1786912007.28224538.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.