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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

132 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
delates8352628(None) 
dealates92716681dealates
debates103718531debates
deflates123013941deflates
delate73827751delate_
delated93722871delated
deletes83117931deletes
derates84028891derates
dilates83220661dilates
elates65032361_elates
gelates83219591gelates
relates73731431relates
ablates92416902ablates
adulates9311912adulates
aerates74627492aerates
alates64833972_alates
belated103520012belated
berates94126872berates
cerates95428252cerates
chelates132713842chelates
dates65639152d__ates
dealate83617842dealate_
dealated103213602dealated
deaths105914442de_aths
deaves105319532de_aves
debases103814132debases
debate94419192debate_
debated113916082debated
debater104114692debater
debaters113511922debaters
decades113615512decades
decanes103118912decanes
decares102818532decares
declares11611312declares
defaces133213402defaces
defames132812252defames
defats105114552defat_s
deflate113613942deflate_
deflated133412302deflated
deflater123211602deflater
deflaters13298702deflaters
degames113312622degames
degases93413102degases
deglazes1935462deglazes
dekares122710872dekares
delaines9312962delaines
delator83015032delator
delators92314832delators
delayed123310762delayed
delayer113010532delayer
delayers12268662delayers
delays104014052dela_ys
deleaves1248062deleaves
delegates1139842delegates
deles65139252del__es
delete73620702delete_
deleted93314912deleted
delfts10439672delft_s
delicates12314312delicates
delimes10314192delimes
dellies83622212dellies
deltas74414822del_tas
delts65731792del_t_s
deludes91810642deludes
deluges9169262deluges
delves104917082del_ves
demotes104717672demotes
denotes83817002denotes
depilates12310922depilates
deplanes11311212deplanes
depletes112810642depletes
deputes104911782deputes
derate74531232derate_
derated93623502derated
derats74625062derat_s
desolates10311792desolates
deviates12312732deviates
devotes113713752devotes
dewater112912422dewater
dewaters122910722dewaters
dewaxes18297842dewaxes
dilate73220692dilate_
dilated93115822dilated
dilater83515652dilater
dilaters92513062dilaters
dilutes82911972dilutes
donates83217222donates
elate55335882_elate_
elated74725822_elated
elater64724202_elater
elaters74420192_elaters
elites66027122_elites
eluates72014682_eluates
elutes64020312_elutes
enates64026432_enates
fellates11312752fellates
folates103218452folates
gelate73421262gelate_
gelated93615642gelated
gelatis83313512gelatis
gelatos83111522gelatos
ideates8313732ide_ates
legates82917682legates
malates93522612malates
metates92720012metates
negates83215842negates
oblates91913242oblates
oleates7417832oleates
palates93624942palates
pelages10714612pelages
pelites93821992pelites
penates93321602penates
plates85432242_plates
prelates10418572prelates
rebates95123182rebates
redates83423872redates
reflates113115662reflates
relaces93420882relaces
relate64033632relate_
related83327572related
relater73723142relater
relaters83218152relaters
relaxes143215322relaxes
remates93827112remates
replates102919272replates
reslates83619502reslates
sedates83418042sedates
senates73322612senates
slates64934062_slates
solates73523852solates
velate93720142velate_
velites103417302velites

Search took 4 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 Filter1786911076710.360496363.9
2DLD Change Limit1076711323.40631612.2
3Display Results1321320.0462869.6
 (SQL Overall)1786911323.81246875.9
 
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.