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

184 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
captains12181057(None) 
captain112111061captain_
captans111612051capta_ns
attains7310982_attains
caftans12179442cafta_ns
calpains1239762calpains
capelins12311132capelins
caplins113515992cap_lins
capstans1257242capsta_ns
captaincy1842012captaincy
captained1446192captained
captan101613342capta_n_
captions123813222captions
catkins133012562ca_tkins
catlins93818842ca_tlins
cattails1038552cattails
chaplains1645742chaplains
cocaptains1643862cocaptains
contains10316532contains
curtains10259702curtains
papains11312362pap_ains
abstains1047323abstains
acetins9313173acet_ins
actins86321103_act_ins
attain6311753_attain_
attaint7313473_attaint
attaints846493_attaints
bargains1178643bargains
cabins104418923ca__bins
caffeins1645123caffeins
caftan111710123cafta_n_
caimans113811783caima_ns
cains75334303c___ains
calkins133814873ca_lkins
callans94518473calla_ns
calpain11310413calpain_
camails11311753ca_mails
campaigns1643473campaigns
canakins142010463canakins
cancans11311873canca_ns
canikins14219163canikins
cannabins1365783cannabins
cantalas104013523cantalas
cantals93919573canta_ls
cantatas103410093cantatas
canteens1038573canteens
cantina93417253cant_ina
cantinas102713773cant_inas
canting104725903cant_ing
cantons95221203cant_ons
cantraips13255273cantraips
cantrips12318933cantrips
capelans1238013capelans
capelin11510973capelin_
capering132414963capering
capeskins1744073capeskins
capias10318353cap__ias
capiases1239253capiases
capitals12209443capita_ls
capitations1549853capitations
caplin103216303cap_lin_
capons104119503cap__ons
capping143819673cap_ping
cappings15369493cap_pings
caprine11314233cap_rine
capris10415083cap_ri_s
capsaicins1672913capsaicins
capsicins1545173capsicins
capsids1239333cap_sids
capstan1137903capsta_n_
captaincies1752653captaincies
captaining1546073captaining
captainship2062643captainship
caption113513693capt_ion
captious122810573captious
captive1438973capt_ive
captives1538623captives
captors113914983capt_ors
captures1239443captures
capturing1436623capturing
capuchins1843373capuchins
carabins12312353carabins
carbarns1238563carbarns
carlins93921913ca_rlins
carotins102315583carotins
cartages11313313cartages
carting104228283cart_ing
cartons94122473cart_ons
cartoons104012803cartoons
caseins93115053ca_seins
casting104628343cast_ing
castings113614053cast_ings
castling11311233castling
catalos9414163ca_talos
cations94524143ca_tions
catkin123512383ca_tkin_
catlin83819083ca_tlin_
catling104819793ca_tling
catlings113712043ca_tlings
catmint11314463ca_tmint
catmints1236663ca_tmints
catnips1195893ca_tnips
cattail939183cattai_l
cattalos1037933cattalos
catties94023053ca_tties
catting103922643ca_tting
cautions103313183cautions
cavatina1347333cavatina
cavatinas1444783cavatinas
cavatine13310323cavatine
caymans14349513cayma_ns
cephalins1666603cephalins
ceratins102818733ceratins
certain92612213certain_
chains114819703c__hains
chapatis15127943chapati_s
chaplain1546193chaplain_
chitins122713793chit_ins
chitlins13289393chitlins
cipolins1238033cipolins
citrins92614363c_itrins
coaptations1547543coaptations
coapting133511613coapt_ing
coattails1144853coattails
cocains111313923c_ocains
cocaptain1543663cocaptain_
complains1549193complains
contain9315833contain_
cortins92421333cort_ins
cotans81317923c_ota_ns
creatins103617513creatins
cremains1238693cremains
cretins93216423cret_ins
curtails10318243curtails
curtain9319793curtain_
cutins83919983c_ut_ins
cyprians1544213cyprians
cysteins1355733cysteins
destains9311813destains
detains83716093_detains
distains9413603distains
emptins1179403empt_ins
explains1766443explains
fantails1139693fantails
gastrins9310123gastrins
haptens124511343hapt_ens
hatpins123410643ha_tpins
japans1539823jap_a_ns
kaftans14185353kafta_ns
lapins84520683lap__ins
lattins74115483la_ttins
leptins92412693lept_ins
maintains1167103maintains
martians103111613martians
martins93322063mart_ins
matins84527783ma_t_ins
mattins93316143ma_ttins
napkins1336673nap_kins
obtains939163_obtains
pains75138283__p_ains
papain10313793pap_ain_
paphians1545593paphians
partans94418283parta_ns
patins87528783pa_t_ins
pertains102113423pertains
plains85019593__plains
plantains1147493plantains
ratans63819373ra_ta_ns
ratlins73615583ra_tlins
rattails837133rattails
rattans73411953ratta_ns
reattains946443reattains
retains74522253_retains
saponins1039453saponins
satins64930483sa_t_ins
sextains15246813sextains
sprains93013593_sprains
stains64923653__stains
sustains838553sustains
tains54936323___tains
tartans72615823tarta_ns
wagtails1244443wagtails
xanthins1846943xanthins
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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621847.65619091.2
3Display Results1841840.0802300.0
 (SQL Overall)1786911847.90922593.4
 
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.