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

232 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
catnaps119703(None) 
catnap1098381catnap_
catnips1195891catnips
ataps76414832_at_aps
caltraps12327252caltraps
canals84421662ca_nals
canape10913512ca_nape
canapes111213082ca_napes
cannas84518402canna_s
cantals93919572cantals
cantraps12319112cantraps
catenas9313112catena_s
catnaper1294932catnaper
catnapers1364762catnapers
catnip1097972catnip_
catsups1135342catsups
petnaps1145032petnaps
satraps95011642satraps
wataps11248682wat_aps
anas46649863_a_na_s
annals66415923_annals
annas55824883_anna_s
antas55432033_anta_s
atap66722453_at_ap_
atlas55821583_atla_s
atmans84413963_atmans
atmas75721013_atma_s
attars64515313_attars
bantams1149063bantams
bitmaps1344253bitmaps
cabals104020153ca_bals
cabanas112413033cabanas
cacaos104616183ca_caos
cacas95627983ca_ca_s
caesars9410733caesars
caftans12179443caftans
caimans113811783caimans
cains75334303cain__s
calcars11312653calcars
callans94518473callans
callas84526753calla_s
calpacs133110343calpacs
caltrap11297943caltrap_
caltrops12307863caltrops
camas96333523ca_ma_s
camass104114183ca_mass
camps116330263ca__mps
canal75428043ca_na_l
canard9314763ca_nard
canards10311203ca_nards
canary11314693ca_nary
cancans11311873cancans
caners84629203ca_ners
canes75350373ca_n_es
canids95118133ca_nids
canna75919333canna__
cannabis1266033cannabis
cannels93413363cannels
canners93822663canners
cannons94412883cannons
canoes84725883ca_noes
canons85522063ca_nons
canopy1337723ca_nopy
cans65050853ca_n__s
cansos84915383ca_nsos
cantal84122033canta_l
cantala94114673cantala
cantalas104013523cantalas
cantata93811813cantata
cantatas103410093cantatas
canters94827733canters
canthus1248713canthus
cantinas102713773cantina_s
cantles94721413cantles
cantons95221203cantons
cantors94620753cantors
cantos84826973ca_ntos
cantraips13255273cantraips
cantrap113310283cantrap_
cantrips12318933cantrips
cants77036943ca_n_ts
cantus85117763ca_ntus
canvas113813333ca_nvas
canvass12376873canvass
capias10318353capia_s
caps87147893c___aps
captans111612053captans
carats85929023ca_rats
carcass11310513carcass
carhops14329703carhops
carinas93622403carina_s
carnage10311743carnage
carnages11312213carnages
carnal83919203carna_l
carnets93918403carnets
carneys124310543carneys
carnies94123963carnies
carns75937563carn__s
carpals113414623carpals
carps96932253ca__rps
casas75327843ca_sa_s
casbahs1436463casbahs
cashaws15398573cashaws
casuals91410523casuals
catalo8314853cat_alo
catalos9414163catalos
catalpa1136503catalpa
catalpas1246733catalpas
catboats1247873catboats
catcall1139153catcall
catcalls1238323catcalls
catches144320773catches
catchups1744383catchups
catclaws1543633catclaws
catena8312483catena__
catenae9311373catena_e
catenary1346583catenary
catenate10312833catenate
catenates11311813catenates
caterans10313223caterans
caters85336503cat_ers
cates75951893cat__es
catface1436763catface
catfaces1536963catfaces
catfall1237393catfall
catfalls1347063catfalls
catguts1045323catguts
catheads1438123catheads
cations94524143cations
catjang1733923catjang
catjangs1843223catjangs
catkins133012563catkins
catlins93818843catlins
catnapped1692503catnapped
catnapper1562913catnapper
catnappers1682763catnappers
cats66356343cat___s
catspaw1443353catspaw
catspaws1543163catspaws
catsup1036433catsup_
cattail939183cattail
cattails1038553cattails
cattalo938423cattalo
cattalos1037933cattalos
catties94023053catties
catwalk1645323catwalk
catwalks1744793catwalks
causals91411183causals
caveats1239803caveats
caviars1238623caviars
caymans14349513caymans
centals94317053centals
centas85020703centa_s
cetanes9315133cetanes
chaps125326063c__haps
chateaus1346013chateaus
cheaps134613683c_heaps
chinas115119403china_s
citrals91111673citrals
claps95626183c__laps
claptraps1542693claptraps
cognacs1256043cognacs
cotans81317923cot_ans
cottars94412243cottars
cottas84615573cotta_s
craps95328643c__raps
cutlas8313103cutla_s
cutlass938013cutlass
cutups1036813cut_ups
dognaps1134393dognaps
earlaps936393earlaps
entraps9109763entraps
etnas54713933_etna_s
faenas94412763faena_s
fatness103311293fatness
fatwas1249053fatwa_s
faunas94013633fauna_s
flatcaps1563403flatcaps
gateaus866333gateaus
jalaps15299183ja_laps
kanas95326913ka_na_s
kantars11310033kantars
katas95922093kat_a_s
kidnaps1453323kidnaps
knaps115511173__knaps
lanais6316793la_nais
latinas74416463latina_s
madcaps1435243madcaps
maenads1037373maenads
manas76240433ma_na_s
manats84623463ma_nats
mannans93611523mannans
mannas85019803manna_s
mantas85725363manta_s
mantraps12298063mantraps
matrass939403matrass
matsahs1236563matsahs
matzahs2134483matzahs
matzas1749703matza_s
nanas55928633na_na_s
naps66238583___naps
padnags1135083padnags
patinas96318523patina_s
patness92912283patness
petnap1037423petnap_
qanats154112813qa_nats
ratals64219583rat_als
ratans63819373rat_ans
ratbags1035763ratbags
rattans73411953rattans
rattraps1044823rattraps
sannops936693sannops
sannups934463sannups
satangs8479713satangs
satays94411683sat_ays
satrap86212553satrap_
satrapy12497933satrapy
saunas63915433sauna_s
schnaps1443703schnaps
shnaps1148083_shnaps
snaps74719563__snaps
straps87721783_straps
taps66050673__t_aps
tatars64619793tat_ars
traps75727483__traps
unsnaps935423unsnaps
varnas94212823varna_s
watap102111673wat_ap_
watape11208483wat_ape
watapes12228383wat_apes
wattape12135383wattape
wattapes1395253wattapes

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.423422437.4
2DLD Change Limit1340272326.39020974.5
3Display Results2322320.0932494.6
 (SQL Overall)1786912326.90625874.7
 
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.