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

173 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
instating1081221(None) 
unstating10711211unstating
estating92614992_estating
gestating11229982gestating
imitating1238762imitating
inflating13310442inflating
initiating1149622initiating
inserting10914242inserting
insetting1079282insetting
insisting1038822insisting
insnaring1046312insnaring
insolating1149152insolating
installing1146402installing
instancing1344642instancing
instarring1144062instarring
instigating1347152instigating
insulating1139262insulating
insulting1038052insulting
inswathing1742972inswathing
misstating13129312misstating
nictating1237572nictating
notating92513342_notating
nutating92411952_nutating
reinstating1248112reinstating
restating102319412restating
stating83725162__stating
unseating10713202unseating
agitating1138863agitating
animating12312513animating
annotating1146233annotating
astatine8313533_astatine
caseating12311743caseating
castrating1349773castrating
dictating1338883dictating
disrating11714553disrating
disseating121111783disseating
distasting1248023distasting
enslaving1345383enslaving
ensnaring1046383ensnaring
enstatite946193enstatite
enswathing1742683enswathing
hesitating1448003hesitating
ideating10311703i_deating
incaging1288673in_caging
incanting1289903incanting
incasing11610603in_casing
incenting12912063incenting
incepting1489293incepting
inciting11312533in_citing
incubating1597133incubating
indagating1345263indagating
indenting11911263indenting
indicating1449693indicating
indicting1339613indicting
inditing10312113in_diting
inducting1338373inducting
indurating1249243indurating
infatuating1543583infatuating
infecting15109673infecting
infesting13109513infesting
inflaming1546263inflaming
infracting1647353infracting
ingesting11129623ingesting
ingoting1039863in_goting
ingrafting1544893ingrafting
inhaling1239523in_haling
initialing1145883initialing
injecting1997693injecting
inlacing1158373in_lacing
inlaying1247893in_laying
inletting1087873inletting
innovating1444613innovating
inputting1235823inputting
insheathing18102693insheathing
insinuating1244533insinuating
insouling1036823insouling
inspanning1343203inspanning
inspecting1546223inspecting
inspiring1246183inspiring
instant7815353insta__nt
instate71616483instat__e
instated91613343instat_ed
instates81615833instat_es
instilling1145803instilling
instituting1244803instituting
instructing1446293instructing
insuring9311153ins_uring
intimating13410823intimating
intitling1037213in_titling
intonating1148633intonating
intoning9311123in_toning
intorting10311413intorting
intreating11614013intreating
intubating1376713intubating
intuiting1089613intuiting
inundating1244543inundating
invading1336263in_vading
inventing13109973inventing
inverting131013223inverting
investing13119393investing
inviting1239733in_viting
invocating1646333invocating
inweaving1644773inweaving
iodating1038823i_odating
irritating1146293irritating
isatin6412213i_s_atin_
isatine7311763i_s_atine
isatins7310773i_s_atins
isolating1039743isolating
iterating10314253iterating
knitting13257023knit_ting
knotting13236573knot_ting
lactating1239193lactating
lustrating1147783lustrating
militating1348823militating
misdating131010663misdating
miseating121215433miseating
mismating141211823mismating
misrating121014853misrating
misseating131310943misseating
misstarting14125203misstarting
mistaking1699693mistaking
mutating112211753_mutating
negating102012833_negating
netting84018763_net_ting
nidating1039783_nidating
nitrating10312673nitrating
nutting83316233_nut_ting
nystatin1145093nystatin_
nystatins1244753nystatins
outstating1139363outstating
painstaking1852853painstaking
postdating1447163postdating
postmating1548603postmating
reseating102421533reseating
reslating102516993reslating
restaging112410853restaging
restarting11310663restarting
rotating92614553_rotating
sanitating1149653sanitating
sating74735453__s_ating
seating84130683__seating
sensating1039253sens_ating
sinuating1039683sin_uating
skating123613853__skating
slating83724653__slating
staging93818373__staging
staking123919803__staking
staling83925423__staling
staning83922243__staning
staring84527053__staring
starting93116173__starting
statin63921473__statin_
statins73719773__statins
staving113915703__staving
staying114017323__staying
unabating1246753unabating
uncoating12611923uncoating
uncrating12813183uncrating
unhatting1335873unhatting
unsaying1288153uns_aying
unsealing10711043unsealing
unseaming1278113unseaming
unsetting1088993unsetting
unsparing1237713unsparing
unstacking1744993unstacking
unstartling1242383unstartling
unstinting1147303unstinting
unstring9312093unst_ring
unswathing1743303unswathing
upstaging1344113upstaging
upstaring1235963upstaring
upstarting1343883upstarting

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.436409841.7
2DLD Change Limit1486411736.28323657.6
3Display Results1731730.0762276.3
 (SQL Overall)1786911736.79526297.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.