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

292 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
catnip109797(None) 
catnap1098381catnap
catnips1195891catnips
atrip75315752_atrip
canid85526342ca_nid
cannie83819362cannie
cantic103920542cantic
cantrip112910042cantrip
carnie84421092carnie
catkin123512382catkin
catlin83819082catlin
catnaps1197032catnaps
catsup1036432catsup
cattie85221022cattie
acapnia1145913acapnia
acini75718983acini_
acinic104713543acinic
actin74922553act_in
acting95920983acting
actinia91710853actinia
actinic111810553actinic
actins86321103actins
amnia75918643_amnia
amnic95516243_amnic
amnio75218053_amnio
ani37751183_a_ni_
anil46437433_a_nil
anis45746463_a_nis
anti45536363_anti_
antic75728863_antic
antis55033313_antis
atap66722453_at_ap
atonia63816513_atonia
atonic83420473_atonic
atop66124753_at_op
atria56022343_atria
attic75618353_attic
bagnio937523bagnio
bani65334963ba_ni_
batik11614733bat_ik
bating95132253bating
battik1238093battik
beatnik1344863beatnik
cabbie122913353cabbie
cabin94820943ca_bin
cabins104418923cabins
cacti9318643cacti_
cactoid12311033cactoid
caddie104316453caddie
caddis104613383caddis
cadi75732183ca_di_
cadis84428503ca_dis
cadmic1338983cadmic
caging105321023caging
caid77837533ca__id
cain65643913ca__in
cains75334303cain_s
caking134624673caking
calcic9311873calcic
calif104929103ca_lif
caliph13311403ca_liph
calix145317353ca_lix
calkin123515493calkin
caltrap11297943caltrap
caltrop11267643caltrop
camail10314833camail
cambia124913153cambia
cammie124615293cammie
camp106336453ca__mp
campi116217783campi_
can57760143ca_n__
canal75428043ca_nal
canape10913513ca_nape
candid104517853candid
candy115119823ca_ndy
cane66653123ca_n_e
caned85838093ca_ned
caner75334773ca_ner
canes75350373ca_nes
canids95118133ca_nids
canine83826703ca_nine
caning94128623ca_ning
canna75919333ca_nna
cannas84518403cannas
canned95022063canned
cannel84216403cannel
canner84625983canner
cannier94014163cannier
cannily1239263cannily
canning103620133canning
cannon84514443cannon
cannot83616773cannot
canny105817693ca_nny
canoe75627253ca_noe
canon74725303ca_non
canonic11312933canonic
canopy1337723ca_nopy
cans65050853ca_n_s
canso75019403ca_nso
canst74932213ca_nst
cant66362033ca_n_t
cantal84122033cantal
canted94825783canted
canter85230113canter
canthi11310973canthi
cantina93417253cantina
canting104725903canting
cantle84522153cantle
canto74931013ca_nto
canton85722993canton
cantor85621523cantor
cantos84826973cantos
cantraip12326393cantraip
cantrap113310283cantrap
cantrips12318933cantrips
cants77036943ca_nts
cantus85117763cantus
canty105226803ca_nty
cap76758983ca___p
capiz18514563ca_piz
caplin103216303caplin
capric12411803capric
capris10415083capris
capsid11312413capsid
captain112111063captain
cardia9916373cardia
cardio9915673cardio
carhop133610763carhop
carina84325323carina
caring95137993caring
carlin84421823carlin
carn66245433carn__
carnal83919203carnal
carnet84732873carnet
carney115315703carney
carnies94123963carnies
carnify1555883carnify
carns75937563carn_s
carny105822923carn_y
carp85139813ca__rp
carpi94319393carpi_
carting104228283carting
cartop104213563cartop
caseic103212373caseic
casein83216453casein
casing94829103casing
casini84615863casini
casino84317553casino
cassia83714763cassia
cassis84818853cassis
casting104628343casting
cat58282343cat___
catalo8314853catalo
catalpa1136503catalpa
catbird1235243catbird
catch125120373cat_ch
catchup1644793catchup
catchy16559583catchy
cate66254603cat__e
catena8312483catena
catenae9311373catenae
catenas9313113catenas
catenoid1149113catenoid
cater74840723cat_er
caters85336503caters
cates75951893cat_es
catfish1559023catfish
catgut9310803catgut
cation83925503cation
cationic12310013cationic
catkins133012563catkins
catlike132712933catlike
catling104819793catling
catlins93818843catlins
catmint11314463catmint
catnaper1294933catnaper
cats66356343cat__s
catsuit959393catsuit
catsups1135343catsups
cattail939183cattail
catted95422473catted
cattier93317073cattier
catties94023053catties
cattily123210853cattily
catting103922643catting
cattish12410723cattish
cattle85118903cattle
catty104520413cat_ty
caulis85320083caulis
cavie104621593ca_vie
cavil103816493ca_vil
caving124822613caving
cawing124322613cawing
chip116726423c__hip
citing94220183citing
citric102812313citric
citrin82615413citrin
clinic104312793clinic
clip86924003c__lip
clonic104914673clonic
coati75624643coat_i_
coating103525313coating
coatis85122603coat_is
coni65534803c_oni_
conic95329793c_onic
conin76232723c_onin
coting94629253coting
crania82418433crania
crating103725203crating
cratonic1239113cratonic
cutie76925933cut_ie
cutin75022783cut_in
cutins83919983cutins
cutis77723763cut_is
cutup9410093cut_up
cyanic133110773cyanic
cyanid123912043cyanid
cyanin113911453cyanin
cynic124712423c_ynic
danio6319783da_nio
dating85326483dating
eating75134403eating
fating105328673fating
garni6315703garni_
gating84826953gating
genip84415203_genip
hating104929713hating
hatpin112610613hatpin
iatric8312163iatric
kainit10414483kainit
kaonic1238763kaonic
lathi85417203lathi_
lathis95516173lathis
lati46438273lat_i_
latina65621143latina
latino64120473latino
latria62313593latria
lattin64316223lattin
mania75634153ma_nia
manic94629443ma_nic
mantic104120903mantic
mantid93820383mantid
mantis83926033mantis
matin75132853mat_in
mating94832913mating
matins84527783matins
matrix1539843matrix
mattin84416633mattin
nannie63713223nannie
neatnik1143333neatnik
nip56945983___nip
panic93923903pa_nic
pantie84326473pantie
parsnip1146323parsnip
patin76832853pat_in
patina86022193patina
patine85328123patine
patins87528783patins
patio74426353pat_io
patois84319363patois
pattie84020963pattie
paynim1337363paynim
petnap1037423petnap
rani46640113ra_ni_
ranid66429333ra_nid
ranis55235833ra_nis
ratine65131823ratine
rating74938703rating
ratio55227583rat_io
ratlin64116523ratlin
sannop837373sannop
sannup836563sannup
santir6315253santir
satanic939933satanic
sati45539333sat_i_
satin55935223sat_in
sating74735453sating
satins64930483satins
satiny93817983satiny
satis55633683sat_is
satrap86212553satrap
snip66424653__snip
strip77524343_strip
taenia6313193taenia
tannic82811473tannic
tannin62613923tannin
tattie64817513tattie
tip56551223__t_ip
trip66830393__trip
turnip836593turnip
vatic10316423vat_ic
watap102111673wat_ap

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162926.03018692.5
3Display Results2922920.0933139.8
 (SQL Overall)1786912926.26328531.2
 
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.