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

180 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
walleye133624(None) 
walleyed1534151walleyed
walleyes1435601walleyes
allee54932122_alle_e
allege74314652_allege
allele64514562_allele
alley85721672_alley_
alleys95113302_alleys
callee84327292calle_e
galley104215452galley_
galleys11369712galleys
mallee84525592malle_e
rallye95110162rall_ye
valley124311602valley_
valleyed1534012valleyed
valleys13407482valleys
walled104021292walle_d
wallet93327092walle_t
wallets103914832wallets
wallie93216802wall_ie
wally114625092wall_y_
aglee65728493_agle_e
agley96917333_agley_
alee46652323_a_le_e
alkene104114003_alkene
allay85620393_allay_
allayed11138063_allayed
allayer10148213_allayer
allays94313743_allays
allees64521483_allees
alleged9389323_alleged
alleger8319633_alleger
alleges84212573_alleges
alleles73812033_alleles
alloy85519973_alloy_
alloyed11158033_alloyed
alloys94014563_alloys
allude73910903_allude
allure63012943_allure
ally76935643_all_y_
allyl85310543_all_yl
bailee84526013baile_e
bailey115015673bailey_
baileys12388933baileys
ballade104012563ballade
balled94926893balle_d
baller83825203balle_r
ballers94421013ballers
ballet84733973balle_t
ballets93719513ballets
ballsy11508873ballsy_
ballute938543ballute
bally105530103ball_y_
barley115116763barley_
barleys125011843barleys
called94126733calle_d
callees94117783callees
caller85125483calle_r
callers94221963callers
callet84536763calle_t
callets93821703callets
callose9313663callose
college102410443college
dalles74222063dalle_s
dally95324743dall_y_
fallen93813373falle_n
faller94621233falle_r
fallers103917993fallers
galeae74717453ga_leae
galere73716693ga_lere
galilee8312213galile_e
gallate83417133gallate
galled84622863galle_d
gallein8299043gallein
galleon8278713galleon
gallery11468743gallery
gallet73630853galle_t
galleta8399653galleta
galleted1038223galleted
gallets83517403gallets
gally95026173gall_y_
goldeye1234643goldeye
gulley104213163gulley_
gulleys11438523gulleys
hallel93514093halle_l
hallels103310133hallels
haltere103614713haltere
lalled74218753lalle_d
malled94626113malle_d
mallees93315973mallees
mallei84414633malle_i
mallet84433053malle_t
mallets93318493mallets
malleus92911313malleus
mulley114013453mulley_
mulleys12299203mulleys
paleae84820293pa_leae
palely11311933palely_
palled94625163palle_d
pallet84232653palle_t
palleted1139873palleted
pallets93919303pallets
pallette1039513pallette
pally105727123pall_y_
parley116718363parley_
parleyed1436243parleyed
parleyer1335633parleyer
parleys125212383parleys
pollee83623273polle_e
pulley113713403pulley_
pulleys12399143pulleys
ralline73518413ralline
rally84725903rall_y_
rallyes10348553rallyes
sallet63734543salle_t
sallets73719653sallets
sally85129713sall_y_
tallage82712073tallage
taller63721963talle_r
tallest7317093tallest
tally84526863tall_y_
vallate103016563vallate
volley12419743volley_
volleyed1543533volleyed
volleyer1443163volleyer
volleys13316643volleys
wailed104823593waile_d
wailer93720333waile_r
wailers103916813wailers
wale74546443wa_l__e
waled94331003wa_le_d
waler84229293wa_le_r
walers94824493wa_lers
wales86142843wa_le_s
walies95324523walie_s
walked145313783walke_d
walker133914003walke_r
walkers143411483walkers
wall76236103wall___
walla85321033wall__a
wallaby1535073wallaby
wallah124011993wall_ah
wallahs13409473wallahs
wallas95719393wall_as
wallies103320743wallies
walling113520973walling
wallop113310293wall_op
walloped14146833walloped
walloper13147113walloper
wallops123410413wallops
wallow123913513wall_ow
wallowed15148173wallowed
wallower14158943wallower
wallows133613533wallows
walls85529383wall__s
waly105830903wa_l_y_
waney115120323wa_ney_
wanly115118023wanl_y_
warless104015103warless
warlike142410473warlike
watcheye19104273watcheye
wauled104713963waule_d
wavey145115543wa_vey_
waveys15597013wa_veys
wawled133811703wawle_d
waxlike21185973waxlike
waylay1535453waylay_
waylayer1743153waylayer
waylays1634673waylays
wayless13308243wayless
welled103820213welle_d
wellie92814913well_ie
welly114620013well_y_
willed104722453wille_d
willer94021063wille_r
willers103517913willers
willet95124833wille_t
willets104414323willets
willie94116453will_ie
willy115321913will_y_

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.406440125.6
2DLD Change Limit1340271806.22021547.7
3Display Results1801800.0603000.0
 (SQL Overall)1786911806.68626726.1
 
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.