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

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

130 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
phenolating174524(None) 
chelating1549353che__lating
crenelating1445513crenelating
desolating1239463_desolating
peculating1549153p_eculating
percolating1657313percolating
perorating13313133p_erorating
phenolate1447473phenolat__e
phenolated1645243phenolat_ed
phenolates1547013phenolat_es
phentolamine1963163phentolamine
phonating1537813ph__onating
prelocating1647413prelocating
renovating1447423_renovating
acetylating1753274acetylating
annotating1146234_annotating
cannulating1446004cannulating
canulating1349544_canulating
cheating144014524che___ating
checkmating2552434checkmating
conflating16410004_conflating
decollating1545964_decollating
decorating14312074_decorating
deflating142610714_de_flating
defoliating1645824_defoliating
delating103119604_de__lating
denoting10311754_deno__ting
denudating1345264_denudating
depilating1439184_depilating
derogating1348634_derogating
detonating1248824_detonating
elating83423084__e__lating
emendating1444614emen_dating
emulating1239874__emulating
enclaving1546314__enclaving
enflaming1545634__enflaming
enlacing1148774__en_lacing
enplaning1246804__enplaning
enslaving1345384__enslaving
epilating12310964__epilating
etiolating1146974_etiolating
eventuating1543254eventuating
fellating1339244_fe_llating
gelating103015734_ge__lating
generating12310384_generating
granulating1345294granulating
heating114024324_he___ating
hebetating1645794_hebetating
hemolyzing2843514_hemolyzing
hennaing1234994_hen_na_ing
henting113719654_hen___ting
herniating1445984_herniating
hesitating1448004_hesitating
hyphenating2353714hyphen__ating
iceboating1543354icebo_ating
immolating1545044_immolating
inflating13310444__inflating
innovating1444614_innovating
insolating1149154_insolating
isolating1039744__isolating
notating92513344___notating
pelleting1237954p_e_lleting
pelting102917274p_e__l_ting
penalising1347624p_enalising
penalizing2249924p_enalizing
penetrating1447664p_enetrating
perennating1445544peren_nating
perforating1747024perforating
permeating1539924p_ermeating
personating1447674personating
phenacaine1753944phenaca_ine
phenacetin1753224phenacetin_
phenacetins1853034phenacetins
phenazin2245604phen__azin_
phenazine2345644phen__azine
phenazins2345304phen__azins
phenolic1546814phenol__i_c
phenolics1645054phenol__ics
phenologies1749354phenologies
phentolamines2062664phentolamines
photolyzing2953874photolyzing
photostating18135834photostating
plating103823074p____lating
pleating112916054ple___ating
populating1547664p_opulating
postulating1447504postulating
potentiating1554284potentiating
predating13514654pre__dating
predicating1749654predicating
preheating16310724pre_heating
preloading1446584prelo_ading
premolding1644674premol_ding
prenominating1854694prenominating
preplacing1746004pre_placing
preplanting1645924pre_planting
presoaking1736254preso_aking
presolving1644364presol_ving
presorting1339984preso_rting
pretreating1448894pretreating
probating14311184p__robating
pronating12313764p__ronating
prorating12314284p__rorating
prorogating1556054prorogating
protonating1448584protonating
pullulating1442954pullulating
pustulating1445244pustulating
recoating121317464_reco_ating
reenslaving1552474reenslaving
reflating132514714_re_flating
refloating14198324_refloating
regelating1239954_regelating
regulating12310064_regulating
reinflating1545994reinflating
relating92725444_re__lating
relocating13310874_relocating
replating122217394_re_plating
reslating102516994_re_slating
resonating11311264_resonating
reviolating1556244reviolating
revolting1339634_revol_ting
sensating1039254_sen_sating
solating9315594___solating
speculating1645944speculating
throating1398394th_ro_ating
translating1249434translating
variolating1544924variolating
venenating1446014_venenating
venerating14410054_venerating
ventilating1546334_ventilating
violating1337434__violating

Search took 10 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 Filter1786911488190.1561145455.1
2DLD Change Limit1488191309.36015899.5
3Display Results1301300.0801625.0
 (SQL Overall)1786911309.59618621.4
 
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.