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

213 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
coannex163551(None) 
annex12310882__annex
canned95022062c_anned
cannel84216402c_annel
canner84625982c_anner
channel123910482channel
coannexed1942952coannexed
coannexes1843642coannexes
conned95119702co_nned
conner84423962co_nner
convex18367742co_nvex
joannes1436242joannes
reannex1434732reannex
annexe1337813__annexe
banned94721343_banned
banner84421503_banner
bannet84925333_bannet
bonne75124713bo_nne_
bonnes85621453bo_nnes
bonnet85524633bo_nnet
branned104311693branned
branner94212373branner
cancel105316683c_ancel
cancer104220923c_ancer
cane66653123c_a_ne_
caned85838093c_a_ned
caner75334773c_a_ner
canes75350373c_a_nes
canine83826703c_anine_
canines93724033c_anines
canker124422523c_anker
canna75919333c_ann_a
cannas84518403c_annas
cannels93413363c_annels
canners93822663c_anners
cannery123610013c_annery
cannie83819363c_annie
cannier94014163c_annier
cannon84514443c_annon
cannot83616773c_annot
canny105817693c_ann_y
canoe75627253c_anoe_
canoed94618963c_anoed
canoer85121073c_anoer
canoes84725883c_anoes
canted94825783c_anted
canter85230113c_anter
carex144822303c_a_rex
carnet84732873c_arnet
carney115315703c_arney
caudex1636403c_audex
chaine115119223chaine_
chained133812693chained
chaines124518733chaines
chance134617093chance_
chanced154113213chanced
chancel144011773chancel
chancer144215633chancer
chances145218093chances
change124116753change_
changed144214143changed
changer134215543changer
changes134517583changes
channels13388493channels
chanted134015953chanted
chanter123919733chanter
chantey154112543chantey
charnel124010053charnel
chinned134810493chinned
choanae1236863choanae_
chunnel12395303chunnel
clanged114212653clanged
clanger104113493clanger
clanked143812253clanked
coached153313843coached
coacher143714123coacher
coaches144018693coaches
coacted123611613coacted
coagent10313983coagent
coalbox1844113coalbox
coaled95022713coa_led
coaler84121713coa_ler
coalier93416183coalier
coannexing2083163coannexing
coapted123911503coapted
coarse84813903coarse_
coarsen93210323coarsen
coarser93211203coarser
coasted104015953coasted
coaster94219043coaster
coated94927043coa_ted
coatee84327223coa_tee
coatees93816553coatees
coater84329573coa_ter
coax136922983coa___x
coaxed165612513coa_xed
coaxer153912793coa_xer
coaxes154715633coa_xes
cocaine111315173cocaine_
cocaines121314443cocaines
cockney1835873cockney
codex155817583co__dex
cohune1189423cohune_
cohunes1249713cohunes
coigne94612193coigne_
coigned11418663coigned
coignes103912153coignes
coined94523603co_ined
coiner84323783co_iner
coinfer12419393coinfer
cointer93616723cointer
cojones163512103cojones
colander1139033colander
colone85425003colone_
colonel94213283colonel
colones96124433colones
complex2037243complex
cone67256963co__ne_
coned86040053co__ned
cones76457423co__nes
coney105932883co__ney
confer114018683co_nfer
conge85227593co_nge_
congee96024473co_ngee
conger95024273co_nger
conges94928173co_nges
conies84338593co_nies
conine84528553conine_
conines93827793conines
conked135019113co_nked
conker124721553co_nker
conn66229133co_nn__
connect113515743co_nnect
conners94023113co_nners
conns75024233co_nn_s
conte76633203co_nte_
contes84432913co_ntes
context163913433co_ntext
convey144610223co_nvey
cornea84018923co_rnea
corned95224523co_rned
cornel84020053co_rnel
corner84625623co_rner
cornet84436733co_rnet
cornfed1337383cornfed
cornier93017093cornier
coronel94515223coronel
coroner94218203coroner
coronet94227173coronet
cortex15311473co_rtex
cosine83823513cosine_
cosines94122673cosines
counsel948543counsel
counted103815803counted
counter94220153counter
cowinner1334753cowinner
cozened19349183cozened
cozener18328953cozener
crane75331603cra_ne_
craned96121653cra_ned
cranes84330753cra_nes
cranked143812843cranked
cranker133612793cranker
crannied1137893crannied
crannies10313013crannies
crannog1044243crannog
cranny114210273crann_y
cunner83915003c_unner
cyanine122911513cyanine_
cyanines132710543cyanines
donne65520463do_nne_
donned85015743do_nned
donnee74317063do_nnee
fanned104117473_fanned
fanner94218183_fanner
flannel1035423flannel
gannet74321853_gannet
goanna736653goann_a
goannas836223goannas
johannes1842943johannes
lanner64920603_lanner
loaned73816293loa_ned
loaner64416503loa_ner
manned94418643_manned
manner84020513_manner
moaned94514173moa_ned
moaner84415113moa_ner
panne76623653_panne_
panned94123433_panned
panner84224763_panner
pannes85522853_pannes
planned103810153planned
planner93511623planner
ronnel63310883ro_nnel
scanned104110893scanned
scanner94411813scanner
scrannel1044033scrannel
sonnet65923503so_nnet
spandex1735833spandex
spanned104111223spanned
spanner94312563spanner
swanned11358173swanned
tanned75219953_tanned
tanner63722283_tanner
tonne54921433to_nne_
tonner64819203to_nner
tonnes65320853to_nnes
vanned104614483_vanned
vanner94215843_vanner
wanned104318013_wanned
wanner94019623_wanner
wonned104012063wo_nned
wonner95114443wo_nner

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272136.21621561.6
3Display Results2132130.0802662.5
 (SQL Overall)1786912136.70226662.3
 
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.