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

190 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
unstating1071121(None) 
instating10812211instating
unseating10713201unseating
estating92614992_estating
gestating11229982gestating
notating92513342_notating
nutating92411952_nutating
outstating1139362outstating
restating102319412restating
stating83725162__stating
unabating1246752unabating
uncoating12611922uncoating
uncrating12813182uncrating
unhatting1335872unhatting
unsaying1288152uns_aying
unsealing10711042unsealing
unseaming1278112unseaming
unsetting1088992unsetting
unsparing1237712unsparing
unstacking1744992unstacking
unstartling1242382unstartling
unstinting1147302unstinting
unstring9312092unst_ring
unswathing1743302unswathing
upstaging1344112upstaging
upstaring1235962upstaring
upstarting1343882upstarting
agitating1138863agitating
animating12312513animating
annotating1146233annotating
astatine8313533_astatine
caseating12311743caseating
castrating1349773castrating
dictating1338883dictating
disrating11714553disrating
distasting1248023distasting
enslaving1345383enslaving
ensnaring1046383ensnaring
enstatite946193enstatite
enswathing1742683enswathing
hesitating1448003hesitating
imitating1238763imitating
inflating13310443inflating
initiating1149623initiating
inserting10914243inserting
insetting1079283insetting
insisting1038823insisting
insnaring1046313insnaring
insolating1149153insolating
installing1146403installing
instancing1344643instancing
instarring1144063instarring
instigating1347153instigating
insulating1139263insulating
insulting1038053insulting
inswathing1742973inswathing
knitting13257023knit_ting
knotting13236573knot_ting
lactating1239193lactating
lustrating1147783lustrating
misdating131010663misdating
miseating121215433miseating
mismating141211823mismating
misrating121014853misrating
misstating13129313misstating
mistaking1699693mistaking
mutating112211753_mutating
negating102012833_negating
netting84018763_net_ting
nictating1237573nictating
nidating1039783_nidating
nitrating10312673_nitrating
nutting83316233_nut_ting
nystatin1145093nystatin_
nystatins1244753nystatins
outskating1536853outskating
outstaring1137803outstaring
outstarting1245013outstarting
outstaying1446093outstaying
postdating1447163postdating
postmating1548603postmating
pulsating1236343puls_ating
punctuating1643103punctuating
reinstating1248113reinstating
reseating102421533reseating
reslating102516993reslating
restaging112410853restaging
restarting11310663restarting
rotating92614553_rotating
sanitating1149653sanitating
sating74735453__s_ating
seating84130683__seating
sensating1039253sens_ating
skating123613853__skating
slating83724653__slating
staging93818373__staging
staking123919803__staking
staling83925423__staling
staning83922243__staning
staring84527053__staring
starting93116173__starting
statin63921473__statin_
statins73719773__statins
staving113915703__staving
staying114017323__staying
ululating1036643ululating
unaging9510933un__aging
unbaling11310683un_baling
unbearing1239353unbearing
unbelting1237663unbelting
unbolting1236453unbolting
unbracing1437023unbracing
unbraking1636933unbraking
uncaging1268713un_caging
uncaking1539463un_caking
uncaring11312843un_caring
uncasing11511003un_casing
unceasing1239653unceasing
uncoatings1384793uncoatings
uncreating13310473uncreating
undaring10412753un_daring
understating1446543understating
undraping1337333undraping
undrawing1436903undrawing
undulating1247143undulating
unfading1347693un_fading
unfearing1338883unfearing
unfitting1336423unfitting
ungazing1936033un_gazing
unhesitating1652643unhesitating
uniting8315823un__iting
unitizing1947803unitizing
unlacing1148653un_lacing
unlading1058863un_lading
unlaying1258363un_laying
unleading1138673unleading
unloading1137193unloading
unmaking1538133un_making
unmeaning1237953unmeaning
unpaying1456943un_paying
unplaiting1345503unplaiting
unquaking2354593unquaking
unquoting1944763unquoting
unresting10311133unresting
unrooting1098833unrooting
unseeing988293uns_eeing
unselling10810333unselling
unsettling1144433unsettling
unsewing1287433uns_ewing
unsexing1686853uns_exing
unsheathing1892983unsheathing
unshifting1743863unshifting
unsighting1584443unsighting
unsling8313643uns__ling
unsmiling1256873unsmiling
unsnagging1342953unsnagging
unsnapping1542933unsnapping
unsnarling1143913unsnarling
unspeaking1744423unspeaking
unstained1038683unsta_ined
unstate71916213unstat__e
unstated91615813unstat_ed
unstates81314993unstat_es
unsteadying1641793unsteadying
unsteeling1145183unsteeling
unstepping1543443unstepping
unsticking1744943unsticking
unstitching1742643unstitching
unstopping1543753unstopping
unstrapping1652913unstrapping
unstrings1046013unst_rings
unstrung954653unst_rung
unstung834853uns__tung
unswearing1444413unswearing
untacking1636643un_tacking
untieing938863un_tieing
untiring9312003un_tiring
untuning937943un_tuning
untying1138943un_t_ying
unwaning1238133un_waning
unweaving1636133unweaving
unweeting1336473unweeting
unwitting1335583unwitting
updating1236593u_pdating
uprating11311113u_prating
upscaling1444653upscaling
upsetting1275563upsetting
upsoaring1244513upsoaring
upstanding1443713upstanding
urinating10310653urinating

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 Limit1486411906.29623608.8
3Display Results1901900.0932043.0
 (SQL Overall)1786911906.82526181.8
 
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.