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

337 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
vacating1431036(None) 
abating10413972_abating
acting95920982_ac_ting
aviating12311032aviating
evacuating1645682evacuating
faceting1438782faceting
lactating1239192lactating
locating11311502locating
placating1438512placating
vacation131911892vacation
vacations141910552vacations
valeting1238852valeting
valuating1338652valuating
variating13310952variating
vatting113614852va_tting
vaulting12227232vaulting
vaunting12338752vaunting
yachting1734932yachting
aahing1019015763_a_ahing
abasing10610673_abasing
ablating11312003ablating
acarine9316003_acarine
acetin8314693_acetin_
acetins9313173_acetins
aching126521973_ac_hing
acing87429153_ac__ing
actin74922553_ac_tin_
actings104512463_ac_tings
actins86321103_ac_tins
actuating1239233_actuating
acylating1547573_acylating
adapting1236643_adapting
advocating1744483advocating
aerating92821003aerating
airting83616303_airting
amazing1938813_amazing
anting75827023_a_nting
arcading1239763arcading
averting122512733averting
awaiting1238273_awaiting
awaking1547813_awaking
baaing94916163ba_a_ing
baching156017753bac_hing
backdating2045723backdating
backing165523443bac_king
baiting103918883ba_iting
basting104227203ba_sting
bating95132253__bating
batting104422273ba_tting
beating104326873_beating
berating113220763berating
bleating113514503bleating
bloating113512813bloating
boating103721303_boating
borating113414503borating
cacheting1737153cacheting
caching156317503cac_hing
cackling172610943cackling
caging105321023__caging
caking134624673__caking
canaling112016413canaling
caning94128623__caning
canting104725903ca_nting
caring95137993__caring
carting104228283ca_rting
cascading1545673cascading
caseating12311743caseating
casing94829103__casing
casting104628343ca_sting
catling104819793__catling
catting103922643ca_tting
cavatina1347333cavatina
cavatine13310323cavatine
caveating1539293caveating
caving124822613__caving
cawing124322613__cawing
cheating144014523cheating
citing94220183__citing
cleating113518143cleating
coacting133412703coac_ting
coating103525313_coating
coting94629253__coting
crating103725203_crating
creating113921953creating
curating11314293curating
damaging1337393damaging
darting94020663da_rting
dating85326483__dating
daunting103310403daunting
dauting93814763da_uting
dawting123610673da_wting
debating123213733debating
decanting132510633decanting
decaying15239453decaying
delating103119603delating
derating103222283derating
dictating1338883dictating
dilating102714913dilating
divagating1644003divagating
doating93816863_doating
donating10311803donating
ducting113713593duc_ting
easting84924303ea_sting
eating75134403__eating
educating1337933educating
elating83423083_elating
emaciating1546823emaciating
emanating1239003emanating
enacting11311363enac_ting
encaging1258733encaging
encasing11610823encasing
equating18310113equating
escaping1347063escaping
escoting1158713escoting
estating92614993estating
evaluating1456023evaluating
evicting1437483evic_ting
exacting1838523exac_ting
exciting1838023exciting
facetting1535283facetting
facing125321573fac__ing
fagoting1336283fagoting
fainting123312163fainting
farting114120753fa_rting
fasting114522833fa_sting
fating105328673__fating
fatting113818703fa_tting
faulting12237733faulting
fixating1936183fixating
floating123111883floating
furcating1537783furcating
gaiting93716583ga_iting
garaging1139043garaging
garoting10510703garoting
gasting95022763ga_sting
gating84826953__gating
gelating103015733gelating
glaciating1445603glaciating
gloating102611463gloating
gradating1237323gradating
grating93923183_grating
gyrating1337453gyrating
habiting1437533habiting
hacking173720613hac_king
hackling183310163hackling
hafting144014173ha_fting
halting114419073ha_lting
hanting114124483ha_nting
hasting114725193ha_sting
hating104929713__hating
hatting113920233ha_tting
haunting123510053haunting
heating114024323_heating
ideating10311703ideating
incaging1288673incaging
incanting1289903incanting
incasing11610603incasing
inciting11312533inciting
invocating1646333invocating
iodating1038823iodating
jacketing2345643jacketing
jacking214515263jac_king
jaculating2047303jaculating
jaunting16328633jaunting
karting123716063ka_rting
kayaking1534063kayaking
lacerating1349453lacerating
lacewing1435843lacewing
lacing94626233lac__ing
lacking143821543lac_king
lariating10311793lariating
lasting84725243la_sting
legating102313113legating
lichting14268513lichting
ligating102212283ligating
luxating1645613luxating
macerating1549543macerating
macing114221553mac__ing
mackling172710063mackling
maculating1549553maculating
maculing13219583maculing
malting103219083ma_lting
managing1239093managing
mandating1339773mandating
marting103325013ma_rting
masting104325823ma_sting
mating94832913__mating
matting103620143ma_tting
moating104218153_moating
mutating112211753mutating
narrating10310353narrating
negating102012833negating
nictating1237573nictating
nidating1039783nidating
notating92513343notating
nutating92411953nutating
opiating11410093opiating
orating83520323_orating
ovulating1336953ovulating
oxalating1745803oxalating
pacing114522753pac__ing
packaging1945163packaging
packeting1836853packeting
packing164420723pac_king
painting113614423painting
palatine10316073palatine
palpating1438543palpating
pancaking1836383pancaking
panting104025423pa_nting
parading12313863parading
parawing14310583parawing
parting103527383pa_rting
pasting103826553pa_sting
patting103722343pa_tting
picoting1338883picoting
pirating11314513pirating
plating103823073_plating
pleating112916053pleating
prating103424453_prating
pupating1337683pupating
racheting1537793racheting
racing95030533rac__ing
racketing1647873racketing
racking144323663rac_king
radiating111112133radiating
radicating1459073radicating
rafting113815753ra_fting
ranting84025413ra_nting
rating74938703__rating
ratting83822363ra_tting
ravaging1346323ravaging
reacting113317893reac_ting
rebating112418343rebating
recaning111416693recaning
recanting122414823recanting
recasting122414233recasting
reciting113118073reciting
recoating121317463recoating
recrating121318793recrating
redating102620173redating
relating92725443relating
remating112322423remating
rotating92614553rotating
sacaton938993sacaton_
sacatons1038973sacatons
sacking144122703sac_king
sacring103115983sac_ring
sainting93215733sainting
salting84120793sa_lting
saluting9310553saluting
satiating10311813satiating
sating74735453__sating
savaging1356673savaging
scaling103519373_scaling
scanting113914763scanting
scaping123715693_scaping
scaring103421973_scaring
scarting113415263scarting
scathing14269703_scathing
scatting113311813scatting
seating84130683_seating
sedating103014113sedating
skating123613853_skating
slating83724653_slating
solating9315593solating
stating83725163_stating
sweating123213023sweating
tacking144421483tac_king
tackling153211123tackling
tainting93613583tainting
tarting84222653ta_rting
tasting84624213ta_sting
tatting84019523ta_tting
taunting93510933taunting
tauting83316383ta_uting
treating92519613treating
unabating1246753unabating
uncaging1268713uncaging
uncaking1539463uncaking
uncaring11312843uncaring
uncasing11511003uncasing
uncoating12611923uncoating
uncrating12813183uncrating
upcasting1434823upcasting
updating1236593updating
uprating11311113uprating
vacant11415133vaca__nt
vacate11314553vacat__e
vacated1349353vacat_ed
vacates12312833vacat_es
vacationed1643423vacationed
vacationer1543303vacationer
vacationing1753043vacationing
vaccina1435303vac_cina
vaccinating1945193vaccinating
vaccine1437323vac_cine
vacillating1744623vacillating
vacuuming1741903vacuuming
vailing113817953va_iling
valancing1544743valancing
validating1545843validating
valuing11298843va_luing
valving14368553va_lving
vamosing1435593vamosing
vamping152810233va_mping
vanning113912463va_nning
vaporing1437653vaporing
varying1429723va_rying
vaultings13233643vaultings
vealing114217423v_ealing
venting114218093v_enting
vesicating1646903vesicating
vesting114618683v_esting
vetting114216563v_etting
vialing113614163v_ialing
vibrating1537483vibrating
vicing124014243vic__ing
violating1337443violating
visaing11279333visa_ing
visiting1238393visiting
vitiating1338413vitiating
vocation132311983vocation
vocations141911423vocations
vocative1637913vocative
vomiting1437733vomiting
voting103916033v__oting
voyaging1632563voyaging
wafting143911663wa_fting
waisting123615213waisting
waiting113618953wa_iting
wanting114220173wa_nting
wasting114422843wa_sting
wauchting1843473wauchting
yachtings1842663yachtings
yacking174315683yac_king
zacaton1845633zacaton_
zacatons1945703zacatons

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.450397091.1
2DLD Change Limit1461623377.25320151.9
3Display Results3373370.1232739.8
 (SQL Overall)1786913377.82622833.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.