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

222 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
captive143897(None) 
captives1538621captives
active11313742_active
adaptive1445132adaptive
baptise1139552baptise
baptize2036982baptize
caprice1349682caprice
caprine11314232caprine
capsize2037622capsize
caption113513692caption
captivate1645922captivate
capture1138912capture
cattie85221022catti_e
coactive1598622coactive
costive12312842costive
dative10311812da_tive
exaptive2045252exaptive
native9613012na_tive
acceptive1845093acceptive
actives12311523_actives
adoptive1445503adoptive
alive85722513_a_live
amative12311733amative
apatite9312963_apatite
aplite8316393_aplite
arrive91311793_arrive
attire62412383_attire
baptised1335263baptised
baptises1238923baptises
baptism1337803baptism
baptist11311873baptist
baptized2245483baptized
baptizer2134893baptizer
baptizes2136843baptizes
bastile9313913bastile
bawtie113812143bawti_e
cabbie122913353cabbi_e
cacti9318643cacti__
caddice13327733caddice
caddie104316453caddi_e
caitiff1547133caitiff
calcine11315273calcine
calcite11413783calcite
calmative1647033calmative
calve105919923ca__lve
camise103319633ca_mise
cammie124615293cammi_e
campfire1744023campfire
camphine1738373camphine
camphire1745893camphire
campsite1447413campsite
canine83826703ca_nine
cannie83819363canni_e
cantic103920543canti_c
canticle1239703canticle
cantina93417253cantina
canting104725903canting
cantle84522153cant_le
capable13313363capable
capacitive1953153capacitive
cape87242783cap___e
capias10318353cap_ias
capita102913773cap_ita
capital112311523capital
capitate121712183capitate
capitol11258283capitol
capiz18514563cap_i_z
capizes20410373cap_izes
caplin103216303capli_n
caplins113515993caplins
caponize2139113caponize
capote10315733cap_ote
capping143819673capping
capric12411803capri_c
caprices1439893caprices
capriole1276913capriole
capris10415083capri_s
capsid11312423capsi_d
capsids1239333capsids
capsized2255503capsized
capsizes2147203capsizes
capstone1237653capstone
capsule1137353capsule
captain112111063captain
captained1446193captained
captains121810573captains
captan101613343capt_an
captans111612053captans
captioned1445763captioned
captions123813223captions
captious122810573captious
captivated1844763captivated
captivates1745493captivates
captivity1944683captivity
captor104914603capt_or
captors113914983captors
captured1336573captured
capturer1246103capturer
captures1239443captures
capuche1644433capuche
carbide126112493carbide
carbine112918643carbine
cardiae10713713cardiae
caribe103416753ca_ribe
carline93923623carline
carmine112918483carmine
carnie84421093carni_e
cartage10312593cartage
carte75940423cart__e
carting104228283carting
carve106227753ca__rve
cassine93817283cassine
caste75932363cast__e
casting104628343casting
castle84918963cast_le
cate66254603ca_t__e
cation83925503ca_tion
catlike132712933catlike
cattier93317073cattier
catties94023053catties
cattily123210853cattily
catting103922643catting
cattish12410723cattish
cattle85118903ca_ttle
cauline92215603cauline
causative1445833causative
caution93013523caution
cavatine13310323cavatine
cave95941263ca___ve
cavie104621593ca_vi_e
centile94217183centile
centime114513033centime
chappie16298663chappi_e
chastise1348173chastise
chive135117623c__hive
coapting133511613coapting
codrive1337653codrive
conative131214623conative
connive1238993connive
contrive13311353contrive
cootie84223093cooti_e
coppice1537483coppice
crappie13298993crappi_e
creative132812803creative
cuplike1537213cuplike
cuprite1159683cuprite
curative13310403curative
cursive1237833cursive
cutie76925933c_uti_e
cystine1239333cystine
datives11310073da_tives
dautie72914703dauti_e
dawtie103011093dawti_e
daytime1344783daytime
deceptive1746853deceptive
deprive1338303deprive
elative10312453elative
emotive1239193emotive
enactive1338513enactive
eruptive1345793eruptive
exceptive2345683exceptive
festive1339773festive
fictive1537023fictive
furtive1337173furtive
haplite12310703haplite
haptene123810933haptene
haptic13511893hapti_c
inactive1348203inactive
inceptive1677843inceptive
lattice938433lattice
laxative1845093laxative
locative1338683loca_tive
maplike15299273maplike
massive12289773massive
motive113112143_motive
naive85116213na__ive
nappie104112263nappi_e
natives10310823na_tives
optime1079353_optime
pantie84326473panti_e
pantile93918483pantile
partite9317133partite
passive12239593passive
pastie85525523pasti_e
pastime114611973pastime
patine85328123pa_tine
pattie84020963patti_e
peptide122910693peptide
peptize20279483peptize
ragtime1036163ragtime
raphide13138073raphide
rapine85023083rap_ine
rapture937393rapture
ratine65131823ra_tine
ratite65022423ra_tite
reactive13310473reactive
receptive1648333receptive
reptile93914083reptile
restive10315933restive
riptide1036893riptide
saltie63422433salti_e
saltine75018563saltine
saltire73113043saltire
sanative11310473sanative
satire63218003sa_tire
septime1138803septime
sorptive1346473sorptive
stative102612933stative
tactile9310613tactile
tantivy1335563tantivy
tardive1136893tardive
tattie64817513tatti_e
tractive13310043tractive
unitive10310563unitive
updive1234903_updive
uptime1067673_uptime
vocative1637913voca_tive
votive12348933_votive
waive114214603wa__ive
wartime1237743wartime
zaptiah2144293zaptiah
zaptieh2144563zaptieh

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 Limit1340272226.14021828.5
3Display Results2222220.0932387.1
 (SQL Overall)1786912226.63926915.3
 
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.