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

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

77 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
exenterating205422(None) 
exenteration1955302exenteration
exenterations2054482exenterations
exonerating1945552exon_erating
degenerating1545663degen_erating
deuterating1347273_deuterating
entreating11811553__entreating
eventuating1543253event_uating
exaggerating2253183exaggerating
exasperating2253183exasperating
execrating2047883exe__crating
exenterate1795683exenterat__e
exenterated1964803exenterat_ed
exenterates1885383exenterat_es
expectorating2552063expectorating
exuberating2144173ex_uberating
generating12310393_gen_erating
penetrating1447663_penetrating
regenerating1446333regen_erating
reiterating12410503_reiterating
venerating14410053_ven_erating
adulterating1453244adulterating
alliterating1354274alliterating
antedating1277554__antedating
centering122915144_center__ing
counteracting1856284counteracting
crenelating1445514cren_elating
deaerating12311564_de_aerating
decelerating1645594dece_lerating
decentering1546484decenter__ing
denervating1645924_den_ervating
denigrating14146924_denigrating
denitrating13128334_denitrating
emendating1444614emen__dating
enervating1488434__en_ervating
entering91920054__enter__ing
entertain947864__entertain_
entertains1047624__entertains
enumerating1445004e_numerating
estreating11710364__estreating
eviscerating1852674eviscerating
exacerbating2452354ex_acerbating
excerpting2244144ex__cerpting
exerting162211154ex___er_ting
exhilarating2351914exhilarating
exoneration1847654exon_eration
exonerations1947014exon_erations
exonerative2155394exon_erative
expatiating2144364expat_iating
expatriating2253064expatriating
experting1938054ex__per_ting
exserting1736664ex__ser_ting
extenuating1943574ex__tenuating
extirpating2143744ex__tirpating
extorting1746764ex__tor_ting
extracting2047224ex__t_racting
extubating2044424ex__tubating
federating1548854_fe_derating
integrating1349494__integrating
intenerating1346734inten_erating
interacting14411714__interacting
intreating11614014__intreating
iterating10314254___iterating
itinerating1245234itin_erating
obliterating1553394obliterating
overtreating1648554overtreating
pretreating1448894pre_treating
redintegrating1763114redintegrating
reentering1149994reenter__ing
reintegrating1554614reintegrating
remunerating1545424remun_erating
reoperating1449024_reoperating
retreating111414774_re_treating
reverberating1953204reverberating
tentering102313214_tenter__ing
venenating1446014_ven_enating
ventilating1546344_ventilating

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 Filter1786911247900.390458182.1
2DLD Change Limit124790777.14017477.6
3Display Results77770.0501540.0
 (SQL Overall)178691777.58023574.0
 
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.