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

251 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
updating123659(None) 
updarting1334331updarting
uprating11311111uprating
dating85326482__dating
iodating1038822iodating
nidating1039782nidating
opiating11410092opiating
outdating11810862outdating
plating103823072_plating
prating103424452_prating
pupating1337682pupating
redating102620172redating
sedating103014112sedating
undaring10412752undaring
upcasting1434822upcasting
updiving1534222updiving
updrying1534012updrying
upgazing2133312upgazing
upwafting1842062upwafting
abating10413973_abating
ablating11311993ablating
adapting1236643_adapting
aerating92821003aerating
auditing1039033auditing
aviating12311013aviating
bating95132253__bating
beating104326873_beating
berating113220763berating
bleating113514503bleating
bloating113512813bloating
boating103721303_boating
borating113414503borating
cheating144014523cheating
cleating113518133cleating
coating103525313_coating
crating103725203_crating
creating113921953creating
curating11314293curating
daring84928683__daring
darting94020663__darting
dauting93814763__dauting
dawing114819823__dawing
dawting123610673__dawting
dazing175516513__dazing
debating123213733debating
delating103119603delating
derating103222283derating
dilating102714903dilating
doating93816863_doating
donating10311803donating
doting84821913__doting
eating75134403__eating
editing9313133_editing
elating83423083_elating
enditing10311073enditing
epilating12310963epilating
equating18310113equating
estating92614993estating
expiating1938533expiating
fating105328673__fating
fixating1936183fixating
floating123111883floating
furcating1537783furcating
gating84826953__gating
gelating103015733gelating
gloating102611463gloating
gradating1237313gradating
grating93923183_grating
gyrating1337453gyrating
hating104929713__hating
heating114024323_heating
hydrating1746323hydrating
ideating10311703ideating
inditing10312113inditing
inundating1244543inundating
lapidating1445233lapidating
legating102313113legating
ligating102212283ligating
locating11311503locating
luxating1645613luxating
mandating1339773mandating
mating94832913__mating
medaling121912263medaling
mediating13311203mediating
misdating131010663misdating
moating104218153_moating
mutating112211753mutating
negating102012833negating
notating92513343notating
nutating92411953nutating
operating12313723operating
opting94514403op__ting
orating83520323_orating
outdaring1179723outdaring
outeating10814493outeating
outrating10916403outrating
oxidating1845053oxidating
pacing114522753_p_acing
padding123412513_padding
paging104020403_p_aging
paling93530133_p_aling
panting104025423_panting
paring94236493_p_aring
parting103527383_parting
pasting103826553_pasting
patin76832853_p_atin_
patina86022193_p_atina
patine85328123_p_atine
patins87528783_p_atins
patting103722343_patting
paving124519743_p_aving
pawing124519553_p_awing
paying123722163_p_aying
peacing124117073_peacing
peaking144317693_peaking
pealing104123203_pealing
pedaling122412133pedaling
pelting102917273_pelting
petting103720953_petting
phasing133211673_phasing
pirating11314513pirating
pitting103618873_pitting
placing123815283_placing
plaiting113113513_plaiting
planing103418253_planing
planting113515383_planting
platina94413643_platina
platings113611363_platings
platting114813033_platting
playing133816093_playing
pleating112916053pleating
porting103021783_porting
posting105622243_posting
potting103720893_potting
pouting103519943_pouting
praying133717323_praying
predating13514653predating
pudding124010803pud_ding
puddling13218033puddling
pulsating1236343pulsating
punting103318443_punting
putting103218573_putting
quadrating2145653quadrating
radiating111112123radiating
rating74938703__rating
rebating112418343rebating
redacting13612303redacting
relating92725443relating
remating112322413remating
repeating122618983repeating
replating122217393replating
rotating92614553rotating
ruinating1039593ruinating
sating74735453__sating
seating84130683_seating
skating123613843_skating
slating83724653_slating
solating9315593solating
spacing123614493sp_acing
spading113114383sp_ading
spaeing103413543sp_aeing
sparing104823873sp_aring
spatting113111763spatting
spaying133014623sp_aying
speaking153212493speaking
speaning113512243speaning
spearing113216103spearing
spirting112913633spirting
spiting103917623sp_iting
spitting113012323spitting
splatting1235983splatting
splaying14219303splaying
sporting112415463sporting
spotting112812083spotting
spouting113511953spouting
spraying14299883spraying
spurting113111633spurting
stating83725163_stating
sublating12310983sublating
sulfating1338063sulfating
sulphating1644323sulphating
summating1437943summating
supinating1357833supinating
sweating123213023sweating
treating92519613treating
ululating1036643ululating
umlauting1243163umlauting
unabating1246753unabating
unaging9510933u_naging
unbaling11310683unbaling
uncaging1268713uncaging
uncaking1539463uncaking
uncaring11312843uncaring
uncasing11511003uncasing
uncoating12611923uncoating
uncrating12813183uncrating
undoing9312243und_oing
undraping1337333undraping
undrawing1436903undrawing
undulating1247143undulating
undying1238503und_ying
unfading1347693unfading
ungazing1936033ungazing
unhatting1335873unhatting
uniting8315823u_niting
unlacing1148643unlacing
unlading1058863unlading
unlaying1258363unlaying
unmaking1538133unmaking
unpaying1456943unpaying
unplaiting1345503unplaiting
unsaying1288153unsaying
unseating10713203unseating
unstating10711213unstating
unwaning1238133unwaning
upbearing1435033upbearing
upcoming1535173upcoming
update93810293updat__e
updated11369423updat_ed
updater10347253updat_er
updaters11255183updaters
updates10329793updat_es
upending12258133upending
upfling1337093up_fling
upgoing1135353up_going
upgrading1444903upgrading
upheaping1743853upheaping
upheaving1843803upheaving
upleaping1434363upleaping
uplifting1534963uplifting
uploading1334663uploading
uppiling1335853uppiling
upping114013703up__ping
upraising1237263upraising
uprearing1238373uprearing
uprising1138953uprising
uprooting1276903uprooting
upscaling1444653upscaling
upsetting1275563upsetting
upsizing2035413upsizing
upsoaring1244513upsoaring
upspring1335703upspring
upstaging1344113upstaging
upstaring1235963upstaring
upstarting1343883upstarting
upswing1335593up_swing
uptalking1643353uptalking
uptearing1236103uptearing
uptilting1234713uptilting
urinating10310653urinating
vacating14310343vacating

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622517.00020880.3
3Display Results2512510.0932698.9
 (SQL Overall)1786912517.24924650.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.