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

121 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
walleyed153415(None) 
valleyed1534011valleyed
walleye1336241walleye_
walleyes1435601walleyes
allayed11138062_allayed
alleged9389322_alleged
alloyed11158032_alloyed
galleted1038222galleted
palleted1139872palleted
parleyed1436242parleyed
volleyed1543532volleyed
walled104021292wall__ed
walloped14146832walloped
wallowed15148172wallowed
aliened81011743_aliened
allayer10148213_allayer
allee54932123_alle_e_
allees64521483_alle_es
allege74314653_allege_
alleger8319633_alleger
alleges84212573_alleges
allele64514563_allele_
alleles73812033_alleles
alley85721673_alley__
alleys95113303_alley_s
allied74217153_all_ied
allowed111610083_allowed
allseed835953_allseed
alluded9327093_alluded
allured8299173_allured
altered83215753_altered
balled94926893ball__ed
balloted1189043balloted
billeted1137643billeted
bulleted1138393bulleted
called94126733call__ed
callee84327293calle_e_
callees94117783calle_es
callused1135853callused
colleted113011663colleted
dallied93713613dall_ied
fallowed15127753fallowed
faltered122811003faltered
filleted1236603filleted
fleyed13408813__fleyed
fullered1236383fullered
galled84622863gall__ed
galleried1146933galleried
galley104215453galley__
galleys11369713galley_s
gallied94115003gall_ied
galloped12107153galloped
gallused1034193gallused
gleyed11478153__gleyed
halloaed121510153halloaed
halloed113314913hall_oed
hallooed12168773hallooed
hallowed15179503hallowed
haltered123112573haltered
hawkeyed2242403hawkeyed
hollered1237603hollered
lackeyed18104513lackeyed
lalled74218753lall__ed
malled94626113mall__ed
mallee84525593malle_e_
mallees93315973malle_es
milleped1335173milleped
palled94625163pall__ed
paltered113012503paltered
parlayed1435823parlayed
parleyer1335633parleyer
parsleyed1543353parsleyed
pelleted1138203pelleted
pollened1157783pollened
rallied83514083rall_ied
rallye95110163rall_ye_
rallyes10348553rall_yes
sallied83316953sall_ied
sallowed12149033sallowed
swallowed1663583swallowed
tableted1137533tableted
tallaged10257923tallaged
tallied83314753tall_ied
tallowed12157713tallowed
tillered937443tillered
trolleyed1342473trolleyed
unallayed1344073unallayed
unalleged1144453unalleged
unalloyed1343723unalloyed
valeted1139013va_leted
valley124311603valley__
valleys13407483valley_s
volleyer1443163volleyer
wafered14288433wa_fered
wagered12299333wa_gered
wailed104823593wail__ed
waitered1238763waitered
wakened1546873wa_kened
waled94331003wa_l__ed
walked145313783wa_l_ked
wallet93327093wall__et
wallets103914833walle_ts
wallie93216803wall_ie_
wallies103320743wall_ies
walloper13147113walloper
wallower14158943wallower
wally114625093wall_y__
waltzed2033493wa_ltzed
wandered132110793wandered
watered113014963wa_tered
wauled104713963waul__ed
wavered142910433wa_vered
wawled133811703wawl__ed
waxweed2132923waxwe_ed
waylayer1743153waylayer
welled103820213well__ed
weltered12238443weltered
wildered1336633wildered
willed104722453will__ed
willied114611563will_ied
willowed15156773willowed

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.420425454.8
2DLD Change Limit1461621217.43619656.0
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.90222613.4
 
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.