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

318 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
joannes143624(None) 
johannes1842941johannes
bonnes85621452bo_nnes
coannex1635512coannex
goannas836222goannas
janes124928122j_a_nes
johnnies1872992johnnies
jones125028182jo__nes
jounces16369852jounces
joyances2044412joyances
pannes85522852_pannes
tonnes65320852to_nnes
acnes75922623__acnes
alanines8314803alanines
anankes1138763anankes
anes45255933__a_nes
annas55824883__annas
annex12310883__annex
antes56334323__antes
banes74945583_ba_nes
banned94721343_banned
banner84421503_banner
banners94018713_banners
bannet84925333_bannet
bannets94013843_bannets
banns75321233_bann_s
beanies93821093beanies
bennes86019013_bennes
bones76446533bo__nes
bonne75124713bo_nne_
bonnet85524633bo_nnet
bonnets94812803bo_nnets
bonzes175116103bo_nzes
boonies93422483boonies
boranes93720403boranes
botanies10312853botanies
bounces113813683bounces
bournes93615023bournes
bovines12412663bovines
branned104311693branned
branner94212373branner
branners104010923branners
canes75350373_ca_nes
canines93724033_canines
cannas84518403_cannas
canned95022063_canned
cannel84216403_cannel
cannels93413363_cannels
canner84625983_canner
canners93822663_canners
canoes84725883_canoes
chaines124518733chaines
chances145218093chances
changes134517583changes
channel123910483channel
channels13388493channels
coaches144018693coaches
coannexes1843643coannexes
coatees93816553coatees
coaxes154715633coa_xes
cocaines121314443cocaines
cohunes1249713cohunes
coignes103912153coignes
cojones163512103cojones
colones96124433colones
cones76457423co__nes
conges94928173co_nges
conies84338593co_nies
conines93827793conines
conned95119703co_nned
conner84423963co_nner
conners94023113co_nners
conns75024233co_nn_s
contes84432913co_ntes
cosines94122673cosines
cranes84330753cra_nes
crannies10313013crannies
cyanines132710543cyanines
dances95120653_dances
domaines11611063domaines
domines102918973domines
donates83217223donates
donees74519493do_nees
donnas75511323do_nnas
donne65520463do_nne_
donned85015743do_nned
donnee74317063do_nnee
donnees84210363donnees
doyennes1244363doyennes
eosines73718293eosines
fanes84639893_fa_nes
fanned104117473_fanned
fanner94218183_fanner
fanners103914653_fanners
fannies103415643_fannies
fiances12310673fiances
flanes94522423fla_nes
flanges113413273flanges
flannel1035423flannel
flannels1134843flannels
gannet74321853_gannet
gannets83811443_gannets
glances104113143glances
glandes95413833glandes
goalies8316023goalies
goanna736653goann_a
goatees82710443goatees
goonies83618333goonies
granges93516523granges
grannies9312613grannies
guanines989773guanines
hances115621283_hances
hanses95022633_hanses
hoagies112811993hoagies
hoaxes163611693hoa_xes
homines123518643homines
honans94814503honan_s
hones88144493ho__nes
hosannas1143603hosannas
inanes62519803ina_nes
iodines83616633iodines
ionones7313883ionones
jades135222113j_a_des
jakes165023643j_a_kes
jambes175914053j_ambes
jane115031483j_a_ne_
jangles154015683j_angles
japanned1843143japanned
japanner1743013japanner
japanners1842813japanners
japes146322823j_a_pes
jaunces16307423jaunces
jaunts137511883j_aunts
jazzes21347883j_azzes
jeaned143813463jea_ned
jeans126022113jea_n_s
jennet134714953j_ennet
jennets14517633j_ennets
jennies143511623jennies
jinnee13411573j_innee
jinnis13489053j_innis
jinns126013843j_inn_s
jinxes20428233j_inxes
jnanas13207303jna_nas
jobnames1942903jobnames
joes116635893jo___es
joggles164410413joggles
johnnie1772283johnnie
johnny1932193johnn_y
johns15398713jo_hn_s
joinder15337593joinder
joinders16337203joinders
joined144613073jo_ined
joiner134114133jo_iner
joiners144211573joiners
joinings16285243joinings
joins125818413jo_in_s
jointed15378503jointed
jointer14379713jointer
jointers15289323jointers
joints133811453jo_ints
jokes165423333jo__kes
jokiness19227393jokiness
joles125230833jo__les
jollies143516273jollies
joneses1438963joneses
joshes165114853jo_shes
josses135117683jo_sses
jostles143411143jostles
joules134116823jo_ules
jounce153310733jounce_
jounced17337613jounced
journey1734873journey
journeys1843203journeys
journos14134943journos
joyance1944773joyance_
kanes95529373_ka_nes
koans95818623koa_n_s
koines10415733ko_ines
kokanees1143033kokanees
lances84824103_lances
lanes54946793_la_nes
lanner64920603_lanner
lanners73618333_lanners
leanness837373leanness
lianes63819323lia_nes
loaches123613983loaches
loaned73816293loa_ned
loaner64416503loa_ner
loaners73913623loaners
loanings9348013loanings
loans56026463loa_n_s
loathes103513243loathes
loaves94813853loa_ves
longes75925573lo_nges
loonies73919543loonies
lornness836493lornness
lounges84811353lounges
manes76648963_ma_nes
manges94628943_manges
mannas85019803_mannas
manned94418643_manned
manner84020513_manner
manners93417833_manners
manses84225513_manses
mantes84430783_mantes
meanies93620743meanies
meanness1037183meanness
moaned94514173moa_ned
moaner84415113moa_ner
moaners92813553moaners
moans74624373moa_n_s
monades103713823monades
mondes94322353mo_ndes
monies83233163mo_nies
montes84226933mo_ntes
moraines10314363moraines
nances83618643_nances
nannies73015203_nannies
nonages8313843nonages
nonces84418833no_nces
nones55639133no__nes
nonnews1035313no_nnews
nuances938523nuances
oases55330983_oa_ses
oaves84925613_oa_ves
ones46146533_o__nes
opines84820703_opines
oranges84215333oranges
ounces83617773_ounces
ovines94614343_ovines
ozones1539393_ozones
panes76148693_pa_nes
panne76623653_panne_
panned94123433_panned
panner84224763_panner
panners93621273_panners
planes85028083pla_nes
planned103810153planned
planner93511623planner
planners10399933planners
poaches144416943poaches
pointes93216753pointes
ponces104720843po_nces
pones74547043po__nes
ponies84833463po_nies
pontes83627853po_ntes
pounces114113893pounces
prances113618773prances
rances84625443_rances
ranees64623963_ranees
ranges73826923_ranges
reannex1434733reannex
roaches123616213roaches
roadies83317443roadies
roans54926443roa_n_s
romaines10512523romaines
romances12310793romances
ronnel63310883ro_nnel
ronnels7318613ro_nnels
sanes55649073_sa_nes
sanies63031953_sanies
scanned104110893scanned
scanner94411813scanner
scanners10379703scanners
seances93015343seances
shannies113411253shannies
soaves94218673soa_ves
solanines9310083solanines
sonances10310263sonances
sonants7511233sonants
sondes74922873so_ndes
sones55444143so__nes
sonnet65923503so_nnet
sonnets74211993so_nnets
sonnies7315223sonnies
sozines16611263sozines
spanned104111223spanned
spanner94312563spanner
spanners103710773spanners
stances93715963stances
stanes64933403sta_nes
stanines85115673stanines
swanned11358173swanned
tanned75219953_tanned
tanner63722283_tanner
tanners74018393_tanners
tannest72617853_tannest
thanes94918983tha_nes
toadies82914863toadies
tolanes74216313tolanes
tones56048663to__nes
tonne54921433to_nne_
tonner64819203to_nner
tonners73816403to_nners
toonies73719883toonies
townees10269783townees
townies103113623townies
toxines142912263toxines
trances93919643trances
trannies8415013trannies
usances967373usances
vanes85130973_va_nes
vanned104614483_vanned
vanner94215843_vanner
vanners103612843_vanners
wanes85040883_wa_nes
wanned104318013_wanned
wanner94019623_wanner
wanness102610683_wanness
wannest103915003_wannest
womanness1444473womanness
wonned104012063wo_nned
wonner95114443wo_nner
wonners104312813wo_nners
wornness1136363wornness
zanies153219673_zanies
zones145528043zo__nes

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273186.89319443.9
3Display Results3183180.1232585.4
 (SQL Overall)1786913187.42224075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.