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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
deadeye124516(None) 
deadeyes1344561deadeyes
deaden83714322deade_n
deadened1137232deadened
deadener1036742deadener
deadens93410692deadens
deader84220472deade_r
deadest93014882deadest
deadly113811472deadly_
redeye103811792re_deye
academe1244703academe
beaded104922423beade_d
beader94623793beade_r
beaders104120183beaders
beadle93314683bead_le
beady114719923bead_y_
bendee94121023bende_e
daddle94214283d_addle
daddy116212563d_addy_
dead65434243dead___
deadbeat1245803deadbeat
deadeners1146283deadeners
deadhead1444433deadhead
deadlier1036863deadlier
deadline10139053deadline
deadman11238423deadman
deadmen11248573deadmen
deadness1039233deadness
deadpan11225233deadpan
deads75726913dead__s
deafen10389673deafe_n
deafened1335853deafened
deafens11317253deafens
deafer104114813deafe_r
deafest112911513deafest
deafly13389123deafly_
dealate83617843dealate
dealer74122143deale_r
dealers84118613dealers
deaned84620453deane_d
deanery1137613deanery
dearer74822803deare_r
dearest83618673dearest
dearie73319813dea_rie
dearly104615323dearly_
deary95826843dea_ry_
deathy134210233deathy_
deave95022333dea__ve
deaved114916553deave_d
deaves105319533deave_s
debye1138903de__bye
decade104216163decad__e
decadence1555593decadence
decadent1249003decadent
decades113615513decade_s
decree93117783decre_e
deduce1079253de_duce
deeded94615543deede_d
deedy104315893deed_y_
degree82814853degre_e
delete73620703de_lete
deplete103010423deplete
diadem1037583diade_m
diademed1344153diademed
diadems1135393diadems
dragee84415603drage_e
drapey125010583drapey_
drawee104413823drawe_e
dreaded103612023dreade_d
fedayee1445513fedayee
goldeye1234643goldeye
headed114020473heade_d
headend12398363headend
header104422543heade_r
headers113819393headers
heady125117263head_y_
heydey1634633heydey_
heydeys1732863heydeys
leaded84221543leade_d
leaden74515223leade_n
leadened1036153leadened
leadens83610983leadens
leader74824653leade_r
leaders83819603leaders
leady95618603lead_y_
peavey14398793peavey_
peaveys15324063peaveys
reader73628293reade_r
readers83823773readers
ready94821503read_y_
redeyes112910973re_deyes
redye94413473re_d_ye
vendee105617263vende_e

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.436409841.7
2DLD Change Limit134027936.12621878.4
3Display Results93930.0303100.0
 (SQL Overall)178691936.59227107.3
 
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.