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

214 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
captives153862(None) 
captive1438971captive_
actives12311522_actives
baptises1238922baptises
baptizes2136842baptizes
capizes20410372cap_izes
caprices1439892caprices
capsizes2147202capsizes
captions123813222captions
captious122810572captious
captivates1745492captivates
captures1239442captures
catties94023052catti_es
datives11310072da_tives
natives10310822na_tives
active11313743_active_
adaptive1445133adaptive_
apatites10311293_apatites
aphides134711203_aphides
apices104916263_ap_ices
aplites9314933_aplites
apsides103911303_apsides
arrives101311513_arrives
attires72312953_attires
banties94324763banti_es
baptise1139553baptise_
baptised1335263baptised
baptisms1446033baptisms
baptists1236723baptists
baptize2036983baptize_
baptized2245483baptized
baptizer2134893baptizer
baptizers2243443baptizers
bastiles10313353bastiles
bawties124214313bawti_es
cabbies133115163cabbi_es
cactuses1237933cactuses
caddices14297853caddices
caddies113718383caddi_es
caddises12329353caddises
caitiffs1642883caitiffs
calcines12314753calcines
calcites12313003calcites
calices114321693ca_lices
calmatives1744733calmatives
calves115119283ca__lves
camises114218463ca_mises
cammies134016483cammi_es
campfires1844123campfires
camphines1847563camphines
camphires1845783camphires
campsites1546473campsites
candies104125613candi_es
canines93724033ca_nines
canities101519263canities
canticles1339183canticles
cantinas102713783cantinas
cantles94721413cant_les
capes95441923cap___es
capias10318353cap_i_as
capiases1239253capiases
capitals12209453capitals
capitols12247333capitols
caplins113515993capli_ns
caponizes2238703caponizes
capotes11314643cap_otes
cappings15369493cappings
caprice1349683caprice_
caprine11314233caprine_
caprioles1376753caprioles
capris10415083capri__s
capsids1239333capsi_ds
capsize2037623capsize_
capsized2255493capsized
capstones1347373capstones
capsules1236623capsules
captained1446193captained
captains121810573captains
captans111612053capt_ans
caption113513693capti_on
captioned1445763captioned
captivate1645923captivate
captivated1844763captivated
captivities1845943captivities
captivity1944673captivity
captors113914983capt_ors
capture1138913capture_
captured1336573captured
capturer1246093capturer
capturers1344633capturers
capuches1735513capuches
carbides133111693carbides
carbines123617543carbines
caribes113715643ca_ribes
carices114220953ca_rices
caries85147623ca_ri_es
carlines103521653carlines
carmines123617873carmines
carnies94123963carni_es
carries94328013carri_es
cartages11313313cartages
cartes86239473cart__es
carves115128453ca__rves
cassines103116613cassines
cassises103811743cassises
castes85631863cast__es
castings113614053castings
castles94917733cast_les
catches144320773ca_tches
cates75951893ca_t__es
cations94524143ca_tions
cattie85221023catti_e_
cattier93317073catti_er
cattiest103016333catti_est
cattiness112310633cattiness
caudices13337343caudices
causatives1543633causatives
cautions103313183cautions
cautious103110233cautious
caves105639703ca___ves
cavies114525003ca_vi_es
cavities131412613cavities
centiles103615813centiles
centimes124012613centimes
chanties132615803chanti_es
chappies172610103chappi_es
chastises1437703chastises
chives144317593c__hives
cities84524853c_iti_es
coactive1598623coactive_
codrives1437663codrives
connives1339723connives
contrives14311703contrives
cooties93725733cooti_es
copies104130303cop_i_es
coppices1638243coppices
cortices12615013cortices
costive12312843costive_
crappies142911163crappi_es
creatives14279693creatives
cuprites1259023cuprites
curatives1437823curatives
cursives1337103cursives
cuties84927363c_uti_es
cutises94414913c_utises
cutties93118843cutti_es
cystines1339473cystines
dative10311813da_tive_
dauties83315763dauti_es
dawties113312703dawti_es
daytimes1434483daytimes
deprives1438393deprives
elatives1139783elatives
empties11712243empti_es
eruptives1443853eruptives
exaptive2045253exaptive_
fatties103018203fatti_es
haplites1339993haplites
haptenes133810823haptenes
inceptives1775793inceptives
laities7320343laiti_es
lapides103012043lap_ides
lapises93513463lap_ises
latices9313763la_tices
lattices1038383lattices
laxatives1943353laxatives
locatives1446563loca_tives
mantises10317923mantises
mastixes1738253mastixes
motives123611893_motives
naives94914223na__ives
nappies114613403nappi_es
nasties73520493nasti_es
native9613013na_tive_
optimes1148473_optimes
panties94230933panti_es
pantiles103617153pantiles
pappies103214833pappi_es
parties93230863parti_es
passives13228823passives
pasties94529813pasti_es
pastimes123611903pastimes
pastises103616053pastises
patines95225763pa_tines
patties93425143patti_es
peptides132610263peptides
peptizes21269853peptizes
ragtimes1135823ragtimes
raphides14188393raphides
rapines95120863rap_ines
raptures1037583raptures
ratines75328583ra_tines
ratites74920683ra_tites
reptiles103913063reptiles
riptides1136413riptides
salties73725773salti_es
saltines82917793saltines
saltires83112433saltires
satires72617573sa_tires
scanties103215423scanti_es
septimes1238303septimes
statives112710793statives
tantivies1247103tantivies
tapises92914013tap_ises
tatties74120343tatti_es
updives1334713_updives
uptimes1177553_uptimes
vocatives1745883voca_tives
votives13337953_votives
waives123714183wa__ives
wartimes1336963wartimes
zaptiahs2242063zaptiahs
zaptieh2144563zapti_eh
zaptiehs2241863zaptiehs

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.423422437.4
2DLD Change Limit1461622146.87321266.1
3Display Results2142140.0932301.1
 (SQL Overall)1786912147.38924183.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.