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

115 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
nictating123757(None) 
dictating1338881dictating
instating10812212instating
lactating1239192lactating
nictation1189272nictation
nictations1278312nictations
nictitating1444382nictitating
nidating1039782ni_dating
nitrating10312672nitrating
notating92513342n_otating
nutating92411952n_utating
actuating1239233_actuating
agitating1138863agitating
animating12312513ani_mating
annotating1146233annotating
bitting103717293bi_t_ting
catting103922643__catting
coating103525313__coating
crating103725203__crating
dictation12810563dictation
dictations1389703dictations
dilating102714913di_lating
disrating11714553disrating
distasting1248023distasting
eructating1345693eructating
estating92614993_estating
filiating1339253filiating
filtrating1445973filtrating
fitting113516563fi_t_ting
fixating1936183fi_xating
gestating11229983gestating
gitting93215703gi_t_ting
hitting113017273hi_t_ting
ideating10311703_ideating
imitating1238763imitating
incaging1288673inc_aging
incanting1289903incanting
incasing11610603inc_asing
incenting12912063incenting
incepting1489303incepting
inciting11312533inc_iting
incubating1597133incubating
indicating1449693indic_ating
inflating13310443inflating
initiating1149623initiating
iodating1038823_iodating
kitting123214443ki_t_ting
knitting13257023kni_t_ting
librating1239053librating
lichting14268513lic_hting
ligating102212283li_gating
liquating1946313liquating
locating11311503loc_ating
micturating1644883micturating
migrating13910533migrating
militating1348823militating
misdating131010663misdating
miseating121215433miseating
mismating141211823mismating
misrating121014853misrating
misstating13129313misstating
mistaking1699693mistaking
mutating112211753_mutating
narrating10310353narrating
nectarine1146983nectarine
negating102012833n_egating
netting84018763n_et_ting
niching133612433nic__hing
nickeling1645393nickeling
nickering1636573nickering
nicking143516323nic__king
nickling15278703nic_kling
nicknaming1952113nicknaming
nicotin948383nic_otin_
nicotine1058473nic_otine
nicotins1058173nic_otins
nictate9310223nictat__e
nictated1137793nictat_ed
nictates1039593nictat_es
nictitant1154393nictitant
nucleating1346943nucleating
nutting83316233n_ut_ting
nystatin1145093nystatin_
nystatins1244753nystatins
pickaxing2543103pickaxing
picketing1835683picketing
picoting1338883pic_oting
picturing1436033picturing
pirating11314513pi_rating
pitting103618873pi_t_ting
recoating121317463recoating
recrating121318793recrating
redictating1546803redictating
restating102319413restating
rotating92614553_rotating
sanitating1149653sani_tating
scatting113311813_scatting
sinuating1039683sinuating
sitting83519633si_t_ting
situating1038883situating
sonicating1348313sonic_ating
spectating1546623spectating
stating83725163__stating
ticketing1635633ticketing
tictacking19113313tictacking
titrating10310113titrating
uncoating12611923uncoating
uncrating12813183uncrating
unstating10711213unstating
vacating14310363vac_ating
vibrating1537483vibrating
victualing1643403victualing
violating1337443violating
vitiating1338413vitiating
witting113417063wi_t_ting

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411156.36023371.2
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.82626178.0
 
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.