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

298 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
catnap109838(None) 
catnaps1197031catnaps
catnip1097971catnip
atap66722452_at_ap
caltrap11297942caltrap
canal75428042ca_nal
canape10913522ca_nape
canna75919332canna_
cannas84518402cannas
cantal84122032cantal
cantrap113310282cantrap
carnal83919212carnal
catena8312482catena_
catenae9311372catenae
catenas9313112catenas
catnaper1294932catnaper
catnips1195892catnips
catsup1036432catsup
petnap1037422petnap
satrap86212552satrap
watap102111672wat_ap
acinar8310483acinar
acta69524803act_a_
actinal9312293actinal
actual8311023actual
ana39559833_a_na_
anal48037523_a_nal
anas46649863_a_nas
anna45529013_anna_
annal56520763_annal
annas55824883_annas
anta46839583_anta_
antae56828293_antae
antas55432033_antas
ataps76414833_at_aps
atlas55821583_atlas
atma68121773_atma_
atman75520143_atman
atmas75721013_atmas
atonal6514023_atonal
atop66124753_at_op
atrip75315753_atrip
attar56516693_attar
banal75925993ba_nal
bantam10314063bantam
bateau8810573bateau
batman105214063batman
bitmap1235613bitmap
cabal95222153ca_bal
cabana103913563cabana
cabanas112413033cabanas
cabman123812503cabman
caca85528083ca_ca_
cacao95420003ca_cao
cacas95627983ca_cas
caeca93915133caeca_
caecal103713733caecal
caesar8410933caesar
caftan111710123caftan
caftans12179443caftans
caiman103615663caiman
cain65643913cain__
cains75334303cain_s
calcar10312753calcar
calla74827073calla_
callan83619603callan
callas84526753callas
calpac123211063calpac
caltraps12327253caltraps
caltrop11267643caltrop
camas96333523ca_mas
camp106336453ca__mp
can57760143ca_n__
canals84421673ca_nals
canapes111213083ca_napes
canard9314763ca_nard
canary11314693ca_nary
cancan10314103cancan
candy115119823ca_ndy
cane66653123ca_n_e
caned85838093ca_ned
caner75334773ca_ner
canes75350373ca_nes
canid85526343ca_nid
canned95022063canned
cannel84216403cannel
canner84625983canner
cannie83819363cannie
cannon84514443cannon
cannot83616773cannot
canny105817693ca_nny
canoe75627253ca_noe
canon74725303ca_non
canopy1337733ca_nopy
cans65050853ca_n_s
canso75019403ca_nso
canst74932213ca_nst
cant66362033ca_n_t
cantala94114673cantala
cantals93919573cantals
cantata93811813cantata
canted94825783canted
canter85230113canter
canthal12410053canthal
canthi11310973canthi
cantic103920543cantic
cantina93417253cantina_
cantinas102713783cantinas
cantle84522153cantle
canto74931013ca_nto
canton85722993canton
cantonal1038903cantonal
cantor85621523cantor
cantos84826973cantos
cantraip12326393cantraip
cantraps12319113cantraps
cantrip112910043cantrip
cants77036943ca_nts
cantus85117763cantus
canty105226803ca_nty
canvas113813333canvas
cap76758983c___ap
capias10318353capias
captan101613343captan
captans111612053captans
carat75048793ca_rat
carhop133610763carhop
carina84325333carina_
carinae94318593carinae
carinal94318243carinal
carinas93622413carinas
carman103920743carman
carn66245433carn__
carnage10311743carnage
carnet84732873carnet
carney115315703carney
carnie84421093carnie
carns75937563carn_s
carny105822923carn_y
carp85139813ca__rp
carpal103716253carpal
cartop104213563cartop
casa65630863ca_sa_
casas75327843ca_sas
casbah1337903casbah
cashaw14439793cashaw
casual81112863casual
cat58282343cat___
catalo8314853catalo
catalpa1136503catalpa
catboat11412243catboat
catcall1139153catcall
catch125120373cat_ch
catchup1644793catchup
catchy16559583catchy
catclaw1443973catclaw
cate66254603cat__e
catenary1346583catenary
catenate10312833catenate
cater74840723cat_er
cateran9313773cateran
caters85336503caters
cates75951893cat_es
catface1436763catface
catfall1237393catfall
catgut9310803catgut
cathead1338753cathead
cation83925503cation
catjang1733923catjang
catkin123512383catkin
catlin83819083catlin
catnapers1364763catnapers
catnapped1692503catnapped
catnapper1562913catnapper
cats66356343cat__s
catspaw1443353catspaw
catsups1135343catsups
cattail939183cattail
cattalo938423cattalo
catted95422473catted
cattie85221023cattie
cattle85118903cattle
catty104520413cat_ty
catwalk1645323catwalk
caudad10157673caudad
caudal91611483caudal
causal81413203causal
caveat11417723caveat
caviar11310163caviar
cayman133613213cayman
centai84814783centai
cental84420963cental
centas85020703centas
cetane8315283cetane
chap114928493c__hap
chateau1236273chateau
cheap126915943c_heap
china105022483china_
chinas115119403chinas
citral81113893citral
clap86429043c__lap
claptrap1442903claptrap
clinal8311553clinal
clonal8310913clonal
cognac1157273cognac
cotan71521783cot_an
cotans81317923cotans
coteau8311083coteau
cotta75818573cotta_
cottae84615703cottae
cottar84613813cottar
cottas84615573cottas
crap85731843c__rap
cutlas8313103cutlas
cutup9410093cut_up
data56026653dat_a_
dognap1035343dognap
earlap837183earlap
entrap8710563entrap
etna46415263_etna_
etnas54713933_etnas
faena85014203faena_
faenas94412763faenas
fatal84819373fat_al
fatwa1168063fatwa_
fatwas1249053fatwas
fauna84816513fauna_
faunae95210373faunae
faunal94711593faunal
faunas94013633faunas
flatcap1463653flatcap
gateau778113gateau
jalap143612473ja_lap
kana85928533ka_na_
kanas95326913ka_nas
kantar10311153kantar
kata85626023kat_a_
katas95922093kat_as
kidnap1334193kidnap
knap105815403__knap
lanai5319573la_nai
latina65621143latina_
latinas74416463latinas
madcap1336333madcap
maenad939413maenad
mana65341963ma_na_
manas76240433ma_nas
manat76039993ma_nat
manna75522543manna_
mannan85413623mannan
mannas85019803mannas
manta75629913manta_
mantas85725363mantas
mantrap11379823mantrap
matinal9312603matinal
matsah1138233matsah
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
mayhap1635233mayhap
nana46632903na_na_
nanas55928633na_nas
nap56753203___nap
natal53921493nat_al
natant6318733natant
padnag1036073padnag
patina86022193patina_
patinae95414403patinae
patinas96318523patinas
petnaps1145033petnaps
qanat144426843qa_nat
ratal55025113rat_al
ratan53722663rat_an
ratans63819373ratans
ratany93411873ratany
ratbag956563ratbag
rattan63613603rattan
rattrap945263rattrap
sannop837373sannop
sannup836563sannup
satang75711563satang
satay84718463sat_ay
satraps95011643satraps
satrapy12497933satrapy
sauna54117553sauna_
saunas63915433saunas
snap65727033__snap
strap77925263_strap
tap57663883__t_ap
tarnal63716503tarnal
tatar56122063tat_ar
trap67532803__trap
unsnap836203unsnap
varna84516173varna_
varnas94212823varnas
watape11208483wat_ape
wataps11248683wat_aps
wattape12135383wattape

Search took 6 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.373479064.3
2DLD Change Limit1127162985.37620966.5
3Display Results2982980.1102709.1
 (SQL Overall)1786912985.85930498.5
 
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.