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

325 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
agisting103824(None) 
agenting1039382agenting
agitating1138852agitating
airting83616302a_irting
arising83619972aris_ing
assisting1046162assisting
aviating12311012aviating
egesting1039012egesting
existing1639072existing
fisting113818122_fisting
foisting122910502foisting
gaiting93716582gai_ting
gasting95022762_gasting
gifting123810892_gifting
girting93113332_girting
gitting93215702_gitting
gusting93917162_gusting
heisting123411042heisting
histing113720372_histing
hoisting123610902hoisting
joisting16328502joisting
listing84020592_listing
misting103623382_misting
twisting12427812twisting
waisting123615212waisting
whisting15329542whisting
wisting113519742_wisting
abashing1466623abashing
abasing10610673abas_ing
abating10413973a_bating
abetting1158293abetting
abiding11510503abi_ding
ablating11311993ablating
aborting11710253aborting
abusing1049113abus_ing
abutting1137003abutting
accosting1446733accosting
acting95920983a__cting
adapting1236643adapting
addicting1485073addicting
adjusting1843823adjusting
admitting1345033admitting
adopting1237453adopting
advising1336153advis_ing
aerating92820993aerating
ageing84213403ag__eing
agentings1134443agentings
aging77026353ag___ing
agist66325583agist___
agisted938203agist_ed
agists75713173agist__s
agnizing1936833agnizing
agonising1146573agonis_ing
agreeing10295903agreeing
aiding84423613a_i_ding
ailing74331013a_i_ling
aiming94320833a_i_ming
airing74927503a_i_ring
airthing12297953a_irthing
alerting91312383alerting
aliasing9310073aliasing
alibiing1135323alibiing
aliening91510893aliening
alighting1446413alighting
aligning10158533aligning
alining81917043ali_ning
amassing1138003amassing
amusing1039383amus_ing
anguishing1543733anguishing
animating12312503animating
anointing1038623anointing
anting75827023a__nting
arointing1049363arointing
arresting1038633arresting
ashing107824093a__shing
asking116017233a__sking
attesting1036383attesting
auditing1039033auditing
averting122512733averting
awaiting1238273awaiting
baiting103918883bai_ting
banishing1537143banishing
basting104227203_basting
bemisting1438073bemisting
besting104923923_besting
bighting15269453bighting
biting95321823_bi_ting
bitting103717293_bitting
blasting114013423blasting
blissing1136873blissing
boasting113512493boasting
boosting113311053boosting
brisking15329473brisking
brisling112410843brisling
bristling1246663bristling
bursting1138703bursting
busting104221793_busting
casting104628343_casting
citing94220183_ci_ting
coasting113615503coasting
costing104323023_costing
cresting114017043cresting
crisping13319663crisping
crusting113612793crusting
degusting1236163degusting
delisting112710503delisting
desisting112810383desisting
dieting93616833_dieting
digesting12208673digesting
dighting142510843dighting
dinting93520553_dinting
discing113914593_discing
dishing124017103_dishing
disking134615493_disking
dissing94517683_dissing
drifting13338733drifting
dusting93618993_dusting
easting84924303_easting
editing9313133edi_ting
emitting112410353emitting
enisling949633enisling
enlisting1038343enlisting
evicting1437483evicting
eviting11511373evi_ting
exiting15311393exi_ting
faggoting1543313faggoting
fagoting1336283fag_oting
fainting123312163fainting
famishing1845233famishing
fasting114522833_fasting
feasting122011323feasting
feinting123410833feinting
fighting162710083fighting
fishing143913863_fishing
fitting113516563_fitting
flinting123412343flinting
flirting12319013flirting
fliting113514613fli_ting
flitting123010883flitting
frisking16268363frisking
fritting123510703fritting
frosting12311183frosting
gaining94015663gai_ning
garoting10510703garoting
gashing125119233_gashing
gasking134415913_gasking
gasping113714363_gasping
gassing94216333_gassing
gating84826953_g_ating
getting93316563_getting
ghosting1336463ghosting
gibbing13339363_gibbing
gibing103712343_gi_bing
gieing83614853_gi_eing
gigging93311773_gigging
gilding103813003_gilding
gilling93520383_gilling
gimping133710753_gimping
ginning93313983_ginning
gipping133813123_gipping
gipsying1533373_gipsying
girding103611883_girding
girning93210693_girning
girthing13256083_girthing
gittin72910553_gittin_
giving114313883_gi_ving
glinting103210053glinting
gosling93312403_gosling
grating93923183_grating
grifting13299263grifting
gritting10309983gritting
guesting1058463guesting
guising93511413guis_ing
gushing124014223_gushing
gutting93415923_gutting
habiting1437533habi_ting
hasting114725193_hasting
highting16259723highting
hilting113316893_hilting
hinting113919223_hinting
hissing114213143_hissing
hitting113017273_hitting
hoising113414413hois_ing
hosting114318383_hosting
igniting1037363igniting
ingesting11129623ingesting
insisting1038813insisting
irising83614423iris_ing
isling71213873__isling
jesting154317713_jesting
jilting153211743_jilting
jointing16248613jointing
jousting16309353jousting
justing153615163_justing
kilting123213853_kilting
kissing122911053_kissing
kiting114117093_ki_ting
kitting123214443_kitting
knitting13257023knitting
lariating10311783lariating
lasting84725243_lasting
lavishing1644553lavishing
lifting113313273_lifting
ligating102212283ligating
lighting132811833lighting
lilting83515383_lilting
linting83820983_linting
lisping103412753_lisping
listings93310043_listings
lusting83619323_lusting
magicking19113543magicking
masting104325823_masting
milting103619123_milting
minting103020813_minting
missing103619073_missing
musting103221073_musting
nesting84320443_nesting
noising83615173nois_ing
omitting11217743omitting
opiating11410093opiating
ousting84021353_ousting
paginating1447523paginating
painting113614423painting
pasting103826553_pasting
peising103416763peis_ing
pishing134314373_pishing
pissing103914803_pissing
pitting103618873_pitting
pointing112813683pointing
poising103617103pois_ing
positing11312303positing
posting105622243_posting
priesting1239483priesting
printing113216083printing
prising103321453pris_ing
prissing113011453prissing
pristine10313503pristine
questing1838273questing
quieting18228463quieting
quilting18218713quilting
quirting18238383quirting
quisling18218063quisling
quitting18228833quitting
radiating111112123radiating
ragouting1134893ragouting
raising83220533rais_ing
ravishing1634983ravishing
reesting93118273reesting
relisting102414353relisting
resisting103215303resisting
resiting93521123resiting
resting85031183_resting
rifting113515003_rifting
righting132610853righting
rioting82716393_rioting
rising74025883_ris_ing
risking123914243_risking
roasting93012693roasting
roosting93411453roosting
rousting93913273rousting
rusting83821263_rusting
sainting93215733sainting
satiating10311803satiating
seising84018863seis_ing
shifting152910373shifting
shirting123213603shirting
shitting123212653shitting
sifting113014593_sifting
sighting133110863sighting
silting83320483_silting
siting74126623_si_ting
sitting83519633_sitting
skirting13289393skirting
skiting123812493ski_ting
slitting93012583slitting
smiting103014443smi_ting
spirting112913633spirting
spiting103917623spi_ting
spitting113012323spitting
stilting93312393stilting
sting65330243___sting
stinting93415743stinting
suiting83419003sui_ting
swishing15277813swishing
tainting93613583tainting
tasting84624213_tasting
testing86021053_testing
thirsting1335283thirsting
tilting83417103_tilting
tinting84620603_tinting
toasting93410573toasting
toiting83217093toi_ting
trusting93411653trusting
trysting12267053trysting
twistings13264353twistings
twitting12307223twitting
uniting8315823uni_ting
vanishing1646303vanishing
variating13310933variating
vesting114618683_vesting
visaing11279333_visaing
viseing11299163_viseing
vising103915873_vis_ing
visiting1238393_visiting
waistings1352710763waistings
waiting113618953wai_ting
wasting114422843_wasting
westing115020273_westing
whishing18287183whishing
whishting1983563whishting
whisking19286613whisking
whistling1644733whistling
whiting143311303whi_ting
wilting113515913_wilting
wishing144114893_wishing
wising103318223_wis_ing
wisping133711943_wisping
wissing113212943_wissing
witing103522823_wi_ting
witting113417063_witting
worsting1267683worsting
wresting123811833wresting
writing113713893wri_ting
yeasting12188923yeasting
zesting174515333_zesting

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.1701051123.5
2DLD Change Limit1461623257.67319048.9
3Display Results3253250.1262579.4
 (SQL Overall)1786913257.96922423.3
 
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.