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

243 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
auditing103903(None) 
addicting1485072addicting
audibling1343332audibling
auding83616932aud__ing
audition979172audition
auditions1078752auditions
auditive1247162auditive
awaiting1238272awaiting
editing9313132_editing
enditing10311072enditing
inditing10312112inditing
quoiting1836092quoiting
suiting83419002su_iting
uniting8315822_uniting
abating10413973a_bating
abdicating1686153abdicating
abducing1474063abducing
abducting1584083abducting
abetting1158293abetting
abiding11510503a_biding
ablating11312003ablating
aborting11710253aborting
abutting1137003abutting
acting95920983a__cting
adapting1236643adapting
adding93914963a_d_ding
addition1096893addition
additions1186333additions
additive1345863additive
addling10229833a_ddling
adducing1384113adducing
adducting1494303adducting
admiring1236133admiring
admitting1345033admitting
admixing1944133admixing
adopting1237453adopting
adoring9412523a_doring
adulating1178723adulating
advising1336153advising
adzing174110013a_d_zing
aerating92821003aerating
affixing2264333affixing
agenting1039383agenting
agisting1038243agisting
agnizing1936833agnizing
aiding84423613a__iding
ailing74331013a__iling
aiming94320843a__iming
airing74927503a__iring
airting83616303a_irting
alerting91312383alerting
alining81917043a_lining
anodizing2046873anodizing
anointing1038623anointing
antiking13412073antiking
anting75827023a__nting
anviling1239743anviling
arising83619973a_rising
arointing1049363arointing
arriving1237363arriving
aspiring1138873aspiring
assisting1046183assisting
attiring939483attiring
attriting1048693attriting
audient8312303audi_ent
audings9289393aud__ings
audiotaping1551653audiotaping
audit62527883audit___
audited939033audit_ed
auditee8311573audit_ee
auditees946463auditees
auditioned1243403auditioned
auditioning1352703auditioning
auditives1345723auditives
auditor837313audit_or
auditors947613auditors
auditory1245703auditory
audits72814113audit__s
augitic1038283augiti_c
auguring1036383auguring
autoing8314043au_toing
availing1267283availing
averting122512733averting
aviating12311023aviating
avoiding1336783avoiding
baiting103918883_baiting
biting95321823__biting
bruiting11259973bruiting
budding123712403bud_ding
buddying16274793buddying
budgeting1444023budgeting
budging124313023bud_ging
bunting103718833bu_nting
bursting1138703bursting
busting104221793bu_sting
butting103519283bu_tting
citing94220183__citing
coediting1338333coediting
crediting1338843crediting
cuddling13287653cuddling
curating11314293curating
cutting103817493cu_tting
dating85326483__dating
daunting103310403dau_nting
dauting93814763dau__ting
debiting122511203debiting
dicing105718763__dicing
dieing84018653__dieing
dieting93616833__dieting
diking124320243__diking
dining84525133__dining
dinting93520553__dinting
diving113717953__diving
doting84821913__doting
ducting113713593du_cting
duding93913323dud__ing
dueting93814393du_eting
duetting1047183duetting
dunting93418383du_nting
dusting93618993du_sting
eviting11511373_eviting
exciting1838023exciting
exiting15311393_exiting
faulting12237733fau_lting
fliting113514613_fliting
fruiting12229063fruiting
fuddling14247153fuddling
fudging133310013fud_ging
gaiting93716583_gaiting
guesting1058463guesting
guiding102911843gu_iding
guiling93214213gu_iling
guising93511413gu_ising
gusting93917163gu_sting
gutting93415923gu_tting
habiting1437533habiting
haunting123510053hau_nting
huddling14227293huddling
hunting114317123hu_nting
hurting113914033hu_rting
hutting113016033hu_tting
igniting1037363igniting
inciting11312533inciting
indicting1339613indicting
inviting1239733inviting
iodating1038823iodating
iodising1037563iodising
iodizing1936673iodizing
jaundicing2141483jaundicing
jaunting16328633jau_nting
judging17337933jud_ging
juicing1736883ju_icing
justing153615163ju_sting
jutting153313713ju_tting
kiting114117093__kiting
lauding93211903laud__ing
leniting9312353leniting
limiting1138813limiting
lunting83817743lu_nting
lusting83619323lu_sting
luting75221753lu__ting
luxating1645613luxating
mandating1339773mandating
mediating13311203mediating
meriting11314693meriting
mudding123310813mud_ding
muddling13268593muddling
muddying16254543muddying
mulcting13246983mulcting
munting103718773mu_nting
musting103221073mu_sting
mutating112211753mutating
muting93921523mu__ting
mutining11310493mutining
nidating1039783nidating
nudging10328693nud_ging
nudities939683nudities
nudzhing2242033nudzhing
nutating92411953nutating
nutting83316233nu_tting
orbiting1138153orbiting
oughting1335953oughting
ousting84021353ou_sting
outdating11810863outdating
outing74128153ou__ting
plaiting113113513plaiting
positing11312303positing
pudding124010803pud_ding
puddling13218033puddling
pumicing1535843pumicing
punting103318443pu_nting
pupating1337683pupating
putting103218573pu_tting
quailing1838403quailing
quanting1849233quanting
questing1838273questing
quieting18228463quieting
quilting18218713quilting
quiring17159993qu_iring
quirting18238383quirting
quitting18228833quitting
quoining1835893quoining
quoting17310043qu_oting
rabbiting1445033rabbiting
radiating111112133radiating
radioing1039383radioing
reciting113118073reciting
redating102620173redating
reediting11310953reediting
resiting93521123resiting
reuniting10310693reuniting
ruddling11228553ruddling
ruining83514883ru_ining
rusting83821263ru_sting
rutting82718043ru_tting
sardining1137573sardining
sedating103014113sedating
siting74126623__siting
skiting123812503_skiting
smiting103014443_smiting
sopiting11310763sopiting
spiting103917623_spiting
subediting1445303subediting
sudsing92910323sud_sing
suitings9288953su_itings
summiting1445793summiting
taunting93510933tau_nting
tauting83316383tau__ting
toiting83217093_toiting
tufting11289873tu_fting
tutting83515913tu_tting
updating1236593updating
updiving1534223updiving
vaulting12227233vau_lting
vaunting12338753vau_nting
visiting1238393visiting
vomiting1437733vomiting
waiting113618953_waiting
wauchting1843473wauchting
waughting1743123waughting
whiting143311303_whiting
witing103522823__witing
writing113713893_writing

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622436.47022590.7
3Display Results2432430.0932612.9
 (SQL Overall)1786912436.96925640.8
 
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.