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

176 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
catmints123666(None) 
catmint11314461catmint_
calamints1348052calamints
carmines123617862carmines
catkins133012562catkin_s
catlings113712042catlings
catlins93818842catlin_s
varmints1335642varmints
actings104512463act_ings
actins86321103act_in_s
admits9411413_admi_ts
aments85219803_a_ments
amines84727983_a_mines
amins75534323_a_min_s
ammines11312673_ammines
anoints7311063_anoints
armings103811503_armings
aroints7313133_aroints
atmans84413963_atman_s
atomists102610963_atomists
attaints846493attaints
battings114010573battings
cabinets1238283ca_binets
cabins104418923ca_bin_s
cadmiums1544403cadmiums
caimans113811783caiman_s
cains75334303ca__in_s
calamines13312223calamines
calamint12315133calamint_
calcines12314753calcines
calkings15289223calkings
calkins133814873calkin_s
callants104112143callants
callings113613833callings
calming123915973calmin_g
cambists1437023cambists
camions113916133ca_mions
camisas113411923ca_misas
camises114218463ca_mises
camlets114314623ca_mlets
cammies134016483cammi_es
campings154010203campings
canines93724033ca_nines
cannings113710333cannings
cantinas102713773cantinas
cants77036943ca___nts
caplins113515993caplin_s
cappings15369493cappings
captains121810573captain_s
carbines123617533carbines
cardings123812633cardings
carinas93622403ca_rinas
carlines103521643carlines
carlings114015853carlings
carlins93921913carlin_s
carmine112918483carmin_e
carpings133812383carpings
carvings143810203carvings
caseins93115053casein_s
casements1348583casements
casings104013513ca_sings
casinos93512833ca_sinos
cassinas103610633cassinas
cassines103116613cassines
cassinos10309353cassinos
castings113614053castings
casuists1036523casuists
catamite12510593catami_te
catamites1349363catamites
catamounts1452293catamounts
catbirds1344203catbirds
catboats1247873catboats
catchments1944453catchments
catenas9313113cat_enas
catfights1842793catfights
catguts1045323cat_guts
cathects1545793cathects
cations94524143cat_ions
catjangs1843223catjangs
catkin123512383catkin__
catkinate1545823catkinate
catlin83819083catlin__
catling104819793catlin_g
catnips1195893catni_ps
catsuits1045433catsuits
catties94023053catti_es
cattiest103016333cattiest
cattiness112310633cattiness
catting103922643cattin_g
cavings134712543ca_vings
caymans14349513cayman_s
cements112714223c_ements
chemists152710323chemists
chints115117833c__hints
chymists18285603chymists
citrines102513133citrines
citrins92614363citrin_s
claimants1344283claimants
coadmits1345713coadmi_ts
coamings13349293coamings
coatings113811843coat_ings
comings124013533c_omings
comments142913883comments
commits133812383commi_ts
cosmists1237993cosmists
creminis12208253creminis
criminis12257303criminis
cumins103314933c_umin_s
cummins1358963cummin_s
cutins83919983cut_in_s
cutlines102413273cutlines
cuttings11277613cuttings
eatings84616443eat_ings
etamines101611813etamines
etamins91511833etamin_s
faints94818783fa__ints
famines123216263fa_mines
farmings14298223farmings
fatlings12359303fatlings
fitments1376793fitments
gamines103618463ga_mines
gamings114610913ga_mings
gamins94420053ga_min_s
garments1139963garments
gatings95212823gat_ings
haemins122811403haemin_s
haints94417583ha__ints
harmines132715143harmines
harmins123716723harmin_s
hatpins123410643hatpin_s
hutments1345603hutments
jasmines1736623jasmines
jasmins1637083jasmin_s
katcinas1434513katcinas
laments94314853la_ments
laminas93615873la_minas
latents75214313lat_ents
lathings12469853lathings
latinas74416463lat_inas
latinos73613803lat_inos
latrines8515003latrines
lattins74115483lattin_s
matings104516213mat_ings
matins84527783mat_in_s
mattings11369673mattings
mattins93316143mattin_s
mints76834043___mints
paints85921833pa__ints
palmists12268813palmists
patents94815203pat_ents
patients1088763patients
patinas96318523pat_inas
patines95225763pat_ines
patins87528783pat_in_s
patriots1038053patriots
payments1536943payments
raiments1039903raiments
ratfinks1542853ratfinks
ratines75328583rat_ines
ratings84217413rat_ings
ratlines83815293ratlines
ratlins73615583ratlin_s
remints95117293_remints
retints74717013ret_ints
saimins9312113saimin_s
saints65122423sa__ints
sarments10311963sarments
satinets8311733sat_inets
satins64930483sat_in_s
staminas1048853staminas
stints65119763_st_ints
taints64520533__taints
tattings9408823tattings
tints56030923__t_ints
varments1339063varments
varmint12311683varmint_

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 Filter1786911461620.643277902.0
2DLD Change Limit1461621767.21620255.3
3Display Results1761760.0802200.0
 (SQL Overall)1786911767.93922508.0
 
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.