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

129 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
walleyes143560(None) 
walleye1336241walleye_
walleyed1534151walleyed
allees64521482_alle_es
alleges84212572_alleges
alleles73812032_alleles
alleys95113302_alley_s
callees94117782calle_es
galleys11369712galley_s
mallees93315972malle_es
rallyes10348552rall_yes
valleyed1534012valleyed
valleys13407482valley_s
wallets103914832walle_ts
wallies103320742wall_ies
alkenes114212753_alkenes
allayed11138063_allayed
allayer10148213_allayer
allayers11156633_allayers
allays94313743_allay_s
allee54932123_alle_e_
allege74314653_allege_
alleged9389323_alleged
alleger8319633_alleger
allegers9378233_allegers
allele64514563_allele_
alley85721673_alley__
allies63827673_all_ies
alloyed11158033_alloyed
alloys94014563_alloy_s
alludes83610333_alludes
allures72913113_allures
allyls9437273_all_yls
bailees93914383baile_es
baileys12388933bailey_s
ballades114211643ballades
ballers94421013balle_rs
ballets93719513balle_ts
ballies93725743ball_ies
ballutes1037523ballutes
barleys125011843barley_s
callee84327293calle_e_
callers94221963calle_rs
callets93821703calle_ts
calloses10313393calloses
calluses1039323calluses
colleges112410523colleges
dalles74222063dall__es
dallies84023193dall_ies
fallers103917993falle_rs
galeres83514343ga_leres
galilees936333galile_es
gallates92815533gallates
galleass935053galleass
galleins9258693galleins
galleons9258443galleons
galleries10311713galleries
galletas9308133galletas
galleted1038223galleted
gallets83517403galle_ts
galley104215453galley__
gallies84122713gall_ies
galluses936963galluses
goldeyes1344483goldeyes
gulleys11438523gulley_s
hallels103310133halle_ls
halloes104021523hall_oes
halluces1335613halluces
halteres113414603halteres
mallee84525593malle_e_
mallets93318493malle_ts
malleus92911313malle_us
mameyes14376983ma_meyes
mulleys12299203mulley_s
palleted1139873palleted
pallets93919303palle_ts
pallettes1148803pallettes
parleyed1436243parleyed
parleyer1335633parleyer
parleyers1444703parleyers
parleys125212373parley_s
pollees93215333polle_es
pulleys12399143pulley_s
rallies73823343rall_ies
rallye95110163rall_ye_
sallets73719653salle_ts
sallies73227813sall_ies
tallages92312003tallages
tallies73624603tall_ies
tallises82713263tallises
valley124311603valley__
volleyed1543533volleyed
volleyer1443163volleyer
volleyers1542773volleyers
volleys13316643volley_s
wailers103916803waile_rs
walers94824463wa_le_rs
wales86142833wa_l__es
walies95324523wa_l_ies
walkers143411473walke_rs
wallabies1445733wallabies
wallahs13409473wall_ahs
wallas95719393wall__as
walled104021293wall__ed
wallet93327093wall__et
wallie93216803wall_ie_
walloped14146833walloped
walloper13147113walloper
wallopers14136273wallopers
wallops123410413wall_ops
wallowed15148163wallowed
wallower14158933wallower
wallowers15127653wallowers
wallows133613533wall_ows
walls85529383wall___s
wally114625093wall_y__
walruses11554973walruses
waltzes1935953wa_ltzes
warless104015103warle_ss
watcheyes20103743watcheyes
waveys15597013wa_vey_s
waylayer1743153waylayer
waylayers1842943waylayers
waylays1634673waylay_s
wayless13308243wayle_ss
wellies103719073well_ies
willers103517913wille_rs
willets104414323wille_ts
willies103920153will_ies

Search took 9 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 Limit1461621298.39017421.0
3Display Results1291290.0462804.3
 (SQL Overall)1786911298.85920170.6
 
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.