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

159 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
allseed83595(None) 
allseeds943391allseeds
allayed11138062allayed
allee54932122all_ee_
allees64521482all_ees
alleged9389322alleged
allied74217152all_ied
allowed111610082allowed
alloyed11158032alloyed
alluded9327092alluded
allured8299172allured
aniseed839402aniseed
axseed1456992a_xseed
oilseed835782oilseed
abased96514993abas_ed
abashed1357663abashed
ablated102513443ablated
abled86926833abl__ed
abluted10188363abluted
abused95614273abus_ed
agisted938203agisted
aglee65728493agl_ee_
agreed84712503a_greed
ailed66240283ail__ed
airshed11258533airshed
airspeed1143603airspeed
aisled74516183a_isled
alarmed1037743alarmed
alated75625153a_lated
alcoved1375623alcoved
alee46652323a_l_ee_
alerted82512223alerted
alibied1038143alibied
aliened81011743aliened
aligned9128553aligned
alined75221403a_lined
aliped95414283a_liped
allayer10148213allayer
allege74314653all_ege
alleger8319633alleger
alleges84212573alleges
allele64514563all_ele
alleles73812033alleles
alley85721673all__ey
alleys95113303all_eys
allheal1044553allheal
allies63827673all_ies
allod64418383all__od
allotted986873allotted
allover1038583allover
alls46740923alls___
allude73910903allude_
alludes83610333alludes
allure63012943allure_
allurer7348433allurer
allures72913113allures
almsmen1144583almsmen
altered83215743altered
amassed10388633amassed
amused94412513amus_ed
aniseeds944393aniseeds
anteed75616113a_nteed
ashed97829773a__shed
asked106919313a__sked
asleep847283asl_eep
avulsed1133833avuls_ed
axised14438963axis_ed
axled135315813axl__ed
axseeds1533393a_xseeds
ballasted1245453ballasted
balled94926893ball__ed
balloted1189043balloted
ballsier1036523ballsier
bilsted1038033bilsted
blasted104213473blasted
bleed85019803_bl_eed
blessed10319493blessed
blissed10388373blissed
blushed134411753blushed
bugseed1136173bugseed
bullweed1444753bullweed
burseed1049503burseed
called94126733call__ed
callee84327293call_ee_
callees94117783call_ees
callused1135853callused
clashed133614013clashed
clasped123610443clasped
classed104113653classed
closed95317963clos_ed
closeted1135613closeted
coleseed1147403coleseed
dallied93713613dall_ied
fallowed15127753fallowed
flashed144112183flashed
flaxseed1942573flaxseed
fleshed143210263fleshed
flossed11388533flossed
flushed143310973flushed
galled84622863gall__ed
galleted1038223galleted
gallied94115003gall_ied
galloped12107153galloped
gallused1034193gallused
galoshed1334493galoshed
gapeseed1243253gapeseed
glaceed1136203glaceed
glassed93710433glassed
gleed75320573_gl_eed
glossed94410073glossed
halloaed121510153halloaed
halloed113314913hall_oed
hallooed12168773hallooed
hallowed15179493hallowed
hayseed1435633hayseed
illuded9305763illuded
illumed10285863illumed
lalled74218753lal_led
lapsed94712583laps_ed
lased65132343_las_ed
lashed105625213_lashed
lassoed8408743lassoed
lasted74323603_lasted
leveed104111373_leveed
linseed838203linseed
lisped94113423_lisped
listed74322833_listed
lushed104218723_lushed
lusted74319443_lusted
lysed95011563_lys_ed
malled94626113mall__ed
mallee84525593mall_ee_
mallees93315973mall_ees
oilseeds943703oilseeds
palled94625163pall__ed
palleted1139873palleted
palsied102911303palsied
plashed133712643plashed
pulsed94013723puls_ed
rallied83514083rall_ied
rapeseed1144463rapeseed
reseed74823293_reseed
sallied83316953sall_ied
sallowed12149033sallowed
seed55549483___seed
slashed114114853slashed
sloshed11329823sloshed
slushed113611243slushed
tallaged10257923tallaged
tallied83314753tall_ied
tallowed12157713tallowed
ullaged937033ullaged
valleyed1534013valleyed
viseed105310983_viseed
walled104021293wall__ed
walleyed1534153walleyed
walloped14146833walloped
wallowed15148163wallowed
welshed14277203welshed

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271596.42020876.5
3Display Results1591590.0632523.8
 (SQL Overall)1786911596.90625874.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.