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

391 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
captans11161205(None) 
caftans12179441caftans
capstans1257241capstans
captains121810571captains
captan101613341captan_
caftan111710122caftan_
caimans113811782caimans
callans94518472callans
cancans11311872cancans
cantals93919572cantals
cantons95221202cantons
capelans1238012capelans
capias10318352capia_s
capitals12209452capitals
caplins113515992caplins
capons104119502cap_ons
capstan1137912capstan_
captain112111062captain
captions123813222captions
captors113914982captors
cartons94122472cartons
caymans14349512caymans
cotans81317922c_otans
haptens124511342haptens
japans1539822jap_ans
kaftans14185352kaftans
partans94418282partans
ratans63819372ra_tans
rattans73411952rattans
tartans72615822tartans
acetals93411353acetals
acetins9313173acetins
actins86321103_actins
alans55636173_a_lans
altars64518153_altars
antas55432033_anta_s
apian75018333_apian_
appals104812943_appals
aprons8316993_aprons
ataps76414833_a_taps
atmans84413963_atmans
attains7310983_attains
attars64515313_attars
avians93711573_avians
azans146516883_a_zans
banians9312033banians
bantams1149063bantams
banyans1237913banyans
batons85519423ba_tons
battens95313263battens
cabals104020153ca_bals
cabana103913563ca_bana
cabanas112413033ca_banas
cabins104418923ca_bins
cabman123812513cabman_
cabstand1344413cabstand
cabstands1453733cabstands
cacaos104616183ca_caos
cacas95627983ca_ca_s
cactus104912233cact_us
caesars9410733caesars
caftaned1445093caftaned
caiman103615673caiman_
cains75334303ca__ins
cairns85313303ca_irns
calcars11312653calcars
calkins133814873calkins
callan83619603callan_
callant94121223callant
callants104112143callants
callas84526753calla_s
calpacs133110343calpacs
calpains1239763calpains
caltraps12327253caltraps
camas96333533ca_ma_s
camass104114183ca_mass
camions113916133camions
campions143511293campions
canals84421673ca_nals
cancan10314103cancan_
cannas84518403canna_s
cannons94412883cannons
canons85522063ca_nons
cans65050853c___ans
cantal84122033canta_l
cantala94114673cantala
cantalas104013523cantalas
cantata93811813cantata
cantatas103410093cantatas
canteens1038573canteens
canters94827733canters
canthus1248713canthus
cantina93417253cantina
cantinas102713783cantinas
canting104725903canting
cantles94721413cantles
canton85722993canton_
cantors94620753cantors
cantos84826973cant_os
cantraps12319113cantraps
cants77036943cant__s
cantus85117763cant_us
canvas113813333canva_s
canvass12376873canvass
canyons124511593canyons
capelan1139013capelan_
capelins12311133capelins
capers105428143cap_ers
capes95441923cap__es
capfuls1436533capfuls
caphs124515373cap__hs
capiases1239253capiases
capita102913773capita__
capital112311523capita_l
capitate121712183capitate
capitols12247333capitols
capizes20410373capizes
capless114312763capless
caplets114914523caplets
caplin103216303caplin_
capon95221873cap_on_
caporals1238923caporals
capos94826073cap__os
capotes11314643capotes
cappers134419403cappers
capping143819673capping
cappings15369493cappings
caprine11314233caprine
capris10415083cap_ris
caps87147893cap___s
capsids1239333capsids
capstone1237653capstone
capstones1347373capstones
captaincy1842013captaincy
captained1446193captained
caption113513693caption
captious122810573captious
captive1438973captive
captives1538623captives
captor104914603capt_or
capture1138913capture
captures1239443captures
carates95630613carates
carats85929023ca_rats
caravans1338623caravans
carbarns1238563carbarns
carbons115418943carbons
carcass11310513carcass
cardons104519943cardons
careens94514703careens
carinas93622423carinas
caritas93316963carita_s
carlins93921923carlins
carman103920763carman_
carns75937563ca__rns
carotins102315583carotins
carpals113414633carpals
cartage10312593cartage
cartages11313313cartages
cartels94618123cartels
carters95327263carters
cartes86239473cart_es
carting104228283carting
carton84522663carton_
cartoons104012803cartoons
carts78946293cart__s
casas75327843ca_sa_s
casbahs1436463casbahs
caseins93115053caseins
caserns94711223caserns
cashaws15398573cashaws
casitas93312043casita_s
castanet10416193castanet
castanets1146343castanets
casters94729903casters
castes85631863cast_es
casting104628343casting
castings113614053castings
castles94917733castles
castors94919443castors
casts77237793cast__s
casuals91410543casuals
catalo8314853ca_talo
catalos9414163ca_talos
catena8312483ca_tena
catenas9313113ca_tenas
caterans10313223caterans
caters85336503ca_ters
cates75951893ca_t_es
cations94524143cations
catjang1733923catjang
catjangs1843223catjangs
catkins133012563catkins
catlins93818843catlins
catnap1098383ca_tnap
catnaps1197033catnaps
cats66356343ca_t__s
cattail939183cattail
cattails1038553cattails
cattalo938423cattalo
cattalos1037933cattalos
catties94023053catties
catting103922643catting
causals91411183causals
cautions103313183cautions
caveats1239803caveats
caverns124510253caverns
caviars1238623caviars
cayman133613223cayman_
centals94317053centals
centas85020703centa_s
cestas85018543cesta_s
cetane8315283c_etane
cetanes9315133c_etanes
chapatis15127943chapatis
chapeaus1544993chapeaus
chaplains1645743chaplains
chapman1637893chapman_
chapters154012133chapters
chastens13429183chastens
chazans21268123chazans
chazzans21234503chazzans
chetahs15347073chetahs
chitins122713793chitins
chitons122611913chitons
clachans1546413clachans
clans75031013c__lans
claptraps1542693claptraps
claypans1543873claypans
cleans85817053c_leans
coapting133511613coapting
coapts104614013coapt__s
cocaptains1643863cocaptains
contains10316533contains
copals105018943cop_als
copays134911273cop_ays
copens106119963cop_ens
coprahs14338153coprahs
copras103517153copra_s
copters113621283copters
corbans11313173corbans
cortins92421333cortins
costars94218013costars
cotan71521783c_otan_
cottars94412243cottars
cottas84615573cotta_s
cottons9312193cottons
cratons94316033cratons
cretins93216423cretins
crotons93714373crotons
cuppas12458593cuppa_s
currans9310613currans
curtains10259703curtains
curtals93111623curtals
cutins83919983c_utins
cyans105714813c__yans
cyprians1544213cyprians
cytons111710183c_ytons
daltons8310403daltons
damans94715983da_mans
emptins1179403emptins
fastens105511753fastens
fattens105111713fattens
habitans1346623habitans
happens14359173happens
hapten115312983hapten_
haptene123810933haptene
haptenes133810823haptenes
hartals10313023hartals
hastens106214813hastens
hatpins123410643hatpins
hazans183411653ha_zans
hazzans18215783hazzans
heptads1335873heptads
heptane1238363heptane
heptanes1339003heptanes
japan14411233jap_an_
jawans1657843ja_wans
kaftan13185833kaftan_
kalians11310183kalians
kanbans1337723kanbans
kantars11310033kantars
kapas116021743kap_a_s
kappas144410373kappa_s
katas95922103ka_ta_s
lactams1136953lactams
lagans75717783la_gans
lallans74113543lallans
lantana739613lantana
lantanas838263lantanas
lapins84520683lap_ins
laptops1166603laptops
latens64620213la_tens
lattens75014673lattens
lattins74115483lattins
lauans65113533la_uans
leptins92412693leptins
leptons91910433leptons
magians10310753magians
mannans93611523mannans
mantas85725363manta_s
martens93714953martens
martians103111613martians
martins93322063martins
matins84527783ma_tins
mattins93316143mattins
mercaptans1652073mercaptans
naans55815253na__ans
napas75924353nap_a_s
napkins1336673napkins
nappas105511613nappa_s
natant6318733na_tant
octans81411143_octans
orphans1237773orphans
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
paisans93614753paisans
pampeans1444703pampeans
pans65855733__p_ans
papains11312373papains
papas94927493pap_a_s
papaws13419113pap_aws
paphians1545593paphians
parians93519743parians
partan83820573partan_
partons94620513partons
pastas85422873pasta_s
patens84820863pa_tens
patins87528783pa_tins
pattens95414923pattens
pavans115715593pa_vans
peans75437643__peans
pians75126963__pians
plans75731273__plans
platans93413123platans
quartans1736293quartans
radians83013823radians
raglans82410133raglans
ragtags935373ragtags
raitas64417673raita_s
randans8313213randans
raptors94213353raptors
ratals64219583ra_tals
ratan53722663ra_tan_
ratany93411873ra_tany
rattan63613603rattan_
rattens74213403rattens
rattons73815323rattons
replans92814943replans
reptant92817073reptant
salpians1036763salpians
saltant7316773saltant
saltpans1034813saltpans
sampans112411003sampans
sapiens9310173sapiens
sapotas939613sapota_s
sarans64224433sa_rans
satang75711563sa_tang
satangs8479713sa_tangs
satays94411683sa_tays
satins64930483sa_tins
seitans73312303seitans
sextans14349273sextans
shaitans1136413shaitans
spans74528733_sp_ans
speans85417143_speans
sultans72411833sultans
suntans72111733suntans
taipans9269553taipans
tampans113310983tampans
tans46154833___tans
tapas74627713tap_a_s
tarpans92513533tarpans
tartan64217523tartan_
tartana73010193tartana
tartanas8258893tartanas
tartars73313403tartars
tarzans16329923tarzans
tatars64619793ta_tars
tautens7317843tautens
titans63414913_titans
trapans92812463trap_ans
triptans1047363triptans
wangans1149503wangans
wantons103713013wantons
wataps11248683wa_taps
witans93412933_witans
xanthans1845693xanthans
yapons114411773yap_ons
zaptiahs2242063zaptiahs

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 Filter1786911340270.440406115.9
2DLD Change Limit1340273916.62320236.6
3Display Results3913910.1562506.4
 (SQL Overall)1786913917.21924752.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.