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

237 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
catnips119589(None) 
catnaps1197031catnaps
catnip1097971catnip_
canids95118132ca_nids
cantrips12318932cantrips
carnies94123962carnies
catkins133012562catkins
catlins93818842catlins
catnap1098382catnap_
catsups1135342catsups
catties94023052catties
acapnias1255683acapnias
actings104512463actings
actinias101810843actinias
actins86321103act_ins
amnios84912523_amnios
anils56326723_a_nils
anis45746463_a_ni_s
antics84621453_antics
antis55033313_anti_s
ataps76414833_at_aps
atonias73315993_atonias
atonics93613713_atonics
atonies75320953_atonies
atrip75315753_atrip_
attics84413283_attics
bagnios1036073bagnios
banties94324763banties
batiks1239373bat_iks
battiks1337143battiks
beatniks1444043beatniks
cabbies133115163cabbies
cabins104418923ca_bins
caddies113718383caddies
caddis104613383caddi_s
cadis84428503ca_di_s
caids85226423ca__ids
cains75334303ca__ins
califs114915893ca_lifs
caliph13311403ca_liph
caliphs1436753ca_liphs
calkins133814873calkins
caltraps12327253caltraps
caltrops12307863caltrops
camails11311753camails
cammies134016483cammies
camps116330263ca__mps
canals84421663ca_nals
canape10913513ca_nape
canapes111213083ca_napes
candids113812693candids
candies104125613candies
caners84629203ca_ners
canes75350373ca_n_es
canid85526343ca_ni_d
canine83826703ca_nine
canines93724033ca_nines
caning94128623ca_ning
cannas84518403ca_nnas
cannels93413363cannels
canners93822663canners
cannie83819363canni_e
cannier94014163cannier
canniest10313363canniest
cannily1239263cannily
canning103620133canning
cannings113710333cannings
cannons94412883cannons
canoes84725883ca_noes
canons85522063ca_nons
canopy1337723ca_nopy
cans65050853ca_n__s
cansos84915383ca_nsos
cantals93919573cantals
canters94827733canters
canthus1248713canthus
cantic103920543canti_c
cantina93417253cantina
cantinas102713773cantinas
canting104725903canting
cantles94721413cantles
cantons95221203cantons
cantors94620753cantors
cantos84826973ca_ntos
cantraips13255273cantraips
cantraps12319113cantraps
cantrip112910043cantrip_
cants77036943ca_n_ts
cantus85117763ca_ntus
canvas113813333ca_nvas
capias10318353ca_pias
caplins113515993caplins
capris10415083capri_s
caps87147893ca___ps
capsids1239333capsids
captains121810573captains
cardias10715113cardias
carhops14329703carhops
caries85147623ca_ries
carinas93622403carinas
carlins93921913carlins
carnets93918403carnets
carneys124310543carneys
carnie84421093carni_e
carnify1555883carnify
carns75937563carn__s
carps96932253ca__rps
carries94328013carries
caseins93115053caseins
casings104013513casings
casinos93512833casinos
cassias93514343cassias
cassis84818853cassi_s
castings113614053castings
catalos9414163catalos
catalpa1136503catalpa
catalpas1246733catalpas
catbird1235243catbird
catbirds1344203catbirds
catches144320773catches
catchups1744383catchups
catenas9313113catenas
catenoids1246433catenoids
caters85336503cat_ers
cates75951893cat__es
catfish1559023catfish
catguts1045323catguts
cation83925503cat_ion
cations94524143cations
catkin123512383catki_n
catlike132712933catlike
catlin83819083catli_n
catling104819793catling
catlings113712043catlings
catmint11314463catmint
catmints1236663catmints
catnaper1294933catnaper
catnapers1364763catnapers
cats66356343cat___s
catsuits1045433catsuits
catsup1036433catsup_
cattails1038553cattails
cattie85221023catti_e
cattier93317073cattier
cattiest103016333cattiest
cattily123210853cattily
catting103922643catting
cattish12410723cattish
caulis85320083cauli_s
cavies114525003ca_vies
cavils114014393ca_vils
cavings134712543cavings
chanties132615803chanties
chips125721253c__hips
cities84524853cit_ies
citrins92614363citrins
clinics11338743clinics
clips96018303c__lips
coatings113811843coatings
coatis85122603coat_i_s
conics103920593c_onics
conies84338593c_onies
conins84327233c_onins
crannies10313013crannies
cronies9622503cronies
cuties84927363cut_ies
cutins83919983cut_ins
cutis77723763cut_i_s
cutties93118843cutties
cutups1036813cut_ups
cyanids13297933cyanids
cyanins122910013cyanins
cynics13377363c_ynics
danios7314603da_nios
eatings84616443eatings
fannies103415643fannies
fatness103311293fatness
fatties103018203fatties
gatings95212823gatings
genips9469943_genips
hatpins123410643hatpins
kainits1137763kainits
lathis95516173lathi_s
latinas74416463latinas
latinos73613803latinos
latrias71913213latrias
lattins74115483lattins
manias84029033ma_nias
manics103919933ma_nics
mantids103113623mantids
mantis83926033manti_s
matings104516213matings
matins84527783mat_ins
mattins93316143mattins
nannies73015203nannies
neatniks1242763neatniks
nips65830923___nips
panics103815363pa_nics
panties94230933panties
parsnips1245533parsnips
patinas96318523patinas
patines95225763patines
patins87528783pat_ins
patios85221783pat_ios
patness92912283patness
patois84319363patoi_s
patsies93919483patsies
patties93425143patties
paynims1434973paynims
petnaps1145033petnaps
ranids75118703ra_nids
ranis55235833ra_ni_s
ratanies8312923ratanies
ratines75328583ratines
ratings84217413ratings
ratios64922673rat_ios
ratlins73615583ratlins
sanies63031953sa_nies
sannops936693sannops
sannups934463sannups
santims9312603santims
santirs7312963santirs
satins64930483sat_ins
satis55633683sat_i_s
satraps95011643satraps
scanties103215423scanties
snips75818013__snips
strips85719653_strips
taenias7311283taenias
tannins72813223tannins
tatties74120343tatties
tawnies102812503tawnies
tips66436763__t_ips
trips74923363__trips
turnips935013turnips
wataps11248683wat_aps
zanies153219673za_nies

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 Limit1340272376.26621389.6
3Display Results2372370.0763118.4
 (SQL Overall)1786912376.74826480.6
 
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.