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

335 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
agenting103938(None) 
agentings1134441agentings
abetting1158292abetting
absenting1236992absenting
accenting1487822accenting
ageing84213402age__ing
agenizing2046332agenizing
agential958152agential
agentive1248042agentive
agisting1038242agisting
alerting91312382alerting
amending12308912amending
anting75827022a__nting
argentine1047892argentine
assenting1038162assenting
augmenting1443852augmenting
avenging1345862avenging
averting122512732averting
denting94422182_denting
egesting1039012egesting
gentling1048452_gentling
getting93316562_getting
henting113719652_henting
lamenting1237692lamenting
margenting1446152margenting
parenting12611582parenting
patenting1248942patenting
renting84026852_renting
scenting113212812scenting
tenting84621152_tenting
venting114218092_venting
abating10413973a_bating
abegging1334483abegging
ablating11311993ablating
aborting11710253aborting
abutting1137003abutting
accepting1695803accepting
acetin8314693ace_tin_
acetins9313173ace_tins
acting95920983a__cting
adapting1236643adapting
adeeming1254793adeeming
adenine8311213aden_ine
adopting1237453adopting
advecting1645113advecting
adverting1437223adverting
aerating92820993aerating
affecting1845233affecting
ageings9437693age__ings
agelong934973age_long
agencies1138743agencies
agenetic1138203ageneti_c
agenize172910153agen_ize
agent65829643agent___
agented939423agent_ed
agentival1353663agentival
agentives1346443agentives
agentries1048233agentries
agentry11165753agent_ry
agents74816293agent__s
aging77026353ag___ing
agitating1138853agitating
agnizing1936833agnizing
agonising1146573agonising
agonizing2047143agonizing
agreeing10295903agreeing
airting83616303a_irting
alienating1147223alienating
aliening91510893alien_ing
alimenting1344503alimenting
alining81917043alin_ing
amentia9310153amenti_a
amentias1039403amentias
amercing1337193amercing
amounting1236643amounting
anearing9413973anearing
aneling82719503ane_ling
angeling102811733ange_ling
angering102113803ange_ring
annexing1635473annexing
anointing1038623anointing
anteing8312813a__nteing
antings85015583a__ntings
appending1536283appending
argentic1149023argenti_c
argentines1146943argentines
argentite1047813argentite
arointing1049363arointing
aroynting1344633aroynting
arresting1038633arresting
ascending1336283ascending
asserting1038663asserting
atoning83514873aton_ing
attending11136373attending
attesting1036383attesting
auditing1039033auditing
averring12239063averring
aviating12311013aviating
awaiting1238273awaiting
aweing103911253awe__ing
awning105013393a_wn_ing
beating104326873_beating
begetting13186583begetting
belting104119133_belting
bending114420893_bending
besting104923923_besting
betting103921403_betting
bleating113514503bleating
blending12249963blending
blunting11319843blunting
bunting103718833_bunting
cadencing1544963cadencing
cageling12310843cage_ling
canting104725903_canting
caseating12311743caseating
catenating1348683catenating
caveating1539293caveating
cementing1438763cementing
censing104215263_censing
centring112112953_centring
chanting143413533chanting
cheating144014523cheating
cleating113518133cleating
clefting14347583clefting
counting113115263counting
creating113921953creating
cresting114017043cresting
daunting103310403daunting
davening13258873daven_ing
dementing13311043dementing
denning93515173_denning
denoting10311753_denoting
dentin73919573_dentin_
dentine83320243_dentine
dentins83419223_dentins
denying123711293_denying
dieting93616833die_ting
digesting12208673digesting
dinting93520553_dinting
dueting93814393due_ting
duetting1047183duetting
dunting93418383_dunting
eating75134403__eating
ejecting18268163ejecting
electing112113783electing
emending12298893emending
ending83220253__ending
erecting112415063erecting
evening11310223even_ing
everting122213133everting
exerting162211153exerting
faceting1438783face_ting
facetting1535283facetting
faggoting1543313faggoting
fagoting1336283fag_oting
fainting123312163fainting
feinting123410833feinting
felting113515213_felting
fencing132411133_fencing
fending123717603_fending
feting104417793_fe_ting
fetting113517873_fetting
fleeting122910323fleeting
flensing1246973flensing
flinting123412343flinting
fomenting1537233fomenting
fragmenting1843243fragmenting
fretting122711523fretting
fronting12310443fronting
gaeing84617223gae__ing
gaining94015663gain_ing
gaiting93716583_gaiting
ganging103216193_ganging
garmenting1445483garmenting
garoting10510703garoting
gasting95022763_gasting
gating84826953_g_ating
gazetting2043243gazetting
gearing92818843_gearing
gecking154111363_gecking
geeing84313763_ge_eing
gelating103015733_gelating
gelding103911793_gelding
gelling93219763_gelling
gemming13289143_gemming
genseng933983_genseng
gentian8310103_gentian
gentians937563_gentians
gentil74115123_genti_l
gentile83515293_gentile
genuine838373_genuine
gifting123810893_gifting
ginning93313983_ginning
girting93113333_girting
gitting93215703_gitting
gleeting10279173gleeting
glinting103210053glinting
gonging103713033_gonging
granting103514523granting
grating93923183_grating
greeting103112353greeting
grunting10269583grunting
guesting1058463guesting
gunning93413173_gunning
gusting93917163_gusting
gutting93415923_gutting
hanting114124483_hanting
haunting123510053haunting
havening15258553haven_ing
heating114024323_heating
hefting144510913_hefting
hinting113919223_hinting
hunting114317123_hunting
ideating10311703ideating
igniting1037363igniting
incenting12912063incenting
indenting11911263indenting
ingesting11129623ingesting
inventing13109973inventing
jaunting16328633jaunting
jesting154317713_jesting
jetting153815343_jetting
jointing16248613jointing
keening123713153keen_ing
kenning124010543_kenning
ladening1078823laden_ing
lagering102212313lage_ring
latening9711493laten_ing
legating102313113legating
lending94118533_lending
leniting9312353_leniting
lensing84015103_lensing
letting83218533_letting
linting83820983_linting
lunting83817743_lunting
meeting103314963_meeting
melting103317753_melting
mending114018683_mending
mensing103915103_mensing
meting94320593_me_ting
minting103020813_minting
mounting112711813mounting
munting103718773_munting
negating102012833negating
nesting84320443_nesting
netting84018763_netting
omening10310093omen_ing
opening1039923open_ing
orienting1038723orienting
paginating1447523paginating
painting113614423painting
panting104025423_panting
parentings1355613parentings
pargeting1338283parge_ting
pargetting1444943pargetting
peening103318303peen_ing
pelting102917273_pelting
pending114119773_pending
penning103616493_penning
petting103720953_petting
pigmenting1653713pigmenting
planting113515383planting
pleating112916053pleating
pointing112813683pointing
printing113216083printing
punting103318443_punting
quanting1849233quanting
questing1838273questing
ragouting1134893ragouting
ranting84025413_ranting
ravening122611293raven_ing
reesting93118273reesting
relenting102716773relenting
rending93924263_rending
repenting122316553repenting
rerenting102617663rerenting
resenting102619293resenting
resting85031183_resting
retting83425883_retting
sainting93215733sainting
scanting113914763scanting
scending122610583scending
seating84130683_seating
segmenting1445003segmenting
sending94221373_sending
sensing84116953_sensing
setting83621393_setting
sheeting122712823sheeting
shending132511253shending
shunting123610423shunting
signeting1136223signeting
sklenting1475123sklenting
slanting94115093slanting
sleeting93114163sleeting
smelting11339713smelting
spending122712433spending
stetting93410713stetting
stinting93415743stinting
stunting92811503stunting
sweating123213023sweating
sweeting123911313sweeting
tainting93613583tainting
targeting1137303targe_ting
taunting93510933taunting
tending94419163_tending
tensing84616653_tensing
testing86021053_testing
tinting84620603_tinting
treating92519613treating
trending103012833trending
tweeting12267033tweeting
unending10239943unending
upending12258133upending
valentine1245893valentine
valeting1238843vale_ting
vaunting12338753vaunting
vending124015263_vending
venging123710943_venging
vesting114618683_vesting
vetting114216563_vetting
wagering13219523wage_ring
wagoning1336923wagon_ing
wakening1636323waken_ing
wanting114220173_wanting
weening114113973ween_ing
weeting113816053_weeting
welting113615313_welting
wending123816843_wending
westing115020273_westing
wetting114117383_wetting
whetting1535973whetting
wonting113214103_wonting
wresting123811833wresting
yenning11369493_yenning
zesting174515333_zesting

Search took 10 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.1701051123.5
2DLD Change Limit1461623358.95616320.0
3Display Results3353350.1402392.9
 (SQL Overall)1786913359.26619284.6
 
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.