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

205 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
captures123944(None) 
capture1138911capture_
captured1336571captured
capturer1246091capturer
capturers1344631capturers
raptures1037581raptures
cactuses1237932cactuses
capsules1236622capsules
captives1538622captives
captors113914982captor_s
clotures10299022clotures
coutures10311992coutures
cultures10310152cultures
factures13129032factures
matures9314312ma_tures
natures7311962na_tures
pastures10311962pastures
rapture937392rapture_
raptured1155472raptured
recaptures1474462recaptures
ruptures1056682ruptures
waftures1434852waftures
abjures1636523_abjures
adjures1536233_adjures
allures72913113_allures
antres65021003_ant_res
apertures1146473_apertures
apres75426403_ap__res
arcatures1186853arca_tures
armures9510273_armures
assures7611403_assures
attires72312953_attires
attunes737823_attunes
aures55137093_a__ures
azures15510183_a_zures
baptises1238923baptises
baptizes2136843baptizes
battues94610193battu_es
cactus104912233cactu__s
cadres94017933ca__dres
caestuses1144893caestuses
caesuras1055733caesuras
caiques18248793caiqu_es
calentures1244613calentures
calibres1237103calibres
calluses1039323calluses
calques182710193calqu_es
campfires1844123campfires
camphires1845783camphires
campuses1437773campuses
cangues10611823cangu_es
cantered113415983cantered
canters94827733canter_s
cantles94721413cant_les
cantors94620753cantor_s
cantus85117763cantu__s
capered123014043cap_ered
caperer113013403cap_erer
caperers122611723cap_erers
capers105428143cap_er_s
capes95441923cap___es
capfuls1436523capfu_ls
capiases1239253capiases
capizes20410373cap_izes
capotes11314643cap_otes
capouches1843633capouches
cappers134419403capper_s
caprices1439893caprices
capris10415083cap__ris
capsizes2147203capsizes
capstones1347373capstones
capsule1137343capsule_
capsuled1334533capsuled
captains121810573captains
captans111612053capt_ans
captions123813223captions
captious122810573captious
captive1438973captive_
captor104914603captor__
capturing1436623capturing
capuches1735513capuches
carburet12411113carburet
carburets1345203carburets
cares77369183ca___res
carfares13310323carfares
carouses10614503carouses
cartages11313313cartages
carters95327253carter_s
cartes86239473cart__es
casques18278983casqu_es
casters94729903caster_s
castes85631863cast__es
castles94917733cast_les
castors94919443castor_s
catches144320773ca_tches
catered103117773ca_tered
caterer92815943ca_terer
caterers102814403ca_terers
cateress102311613ca_teress
caters85336503ca_ter_s
cates75951893ca_t__es
catteries11815523catteries
catties94023053ca_tties
caucuses1236783caucuses
caules85927253ca__ules
causes88026473ca__uses
cauteries11615393cauteries
caviares1337993caviares
cayuses12188403ca_yuses
ceintures1136733ceintures
censures102211623censures
centares102913893centares
centres93817123cent_res
centuries11311333centuries
cestuses1038083cestuses
chaptered17176793chaptered
chapters154012133chapter_s
cinctures1346063cinctures
cistuses1038283cistuses
closures10228953closures
cloture9238453cloture_
clotured11246163clotured
coenures1048683coenures
coituses1039623coituses
colures9315143c_olures
conjures17119913conjures
contuses10413453contuses
copters113621283copter_s
costumes1258013costumes
couture9310623couture_
creatures1138423creatures
cubatures1344433cubatures
culture939393culture_
cultured1137233cultured
cultuses1037753cultuses
cupules113210263cup_ules
cures75645433c___ures
cutpurse1243133cutpurse
cutpurses1343313cutpurses
cypres1338523cyp__res
cypruses1534313cypruses
dasyures1254153dasyures
daturas838783da_turas
dentures9312453dentures
enraptures1243243enraptures
facture12108933facture_
failures1135163failures
features11310333features
fixtures1835283fixtures
fractures14147253fractures
futures10310263_futures
gestures9310013gestures
gyplures14102153gyplures
hachures1645873hachures
halteres113414603halteres
haptenes133810823haptenes
lectures101310163lectures
manures9313353ma_nures
matres84522233ma_t_res
mature8313473ma_ture_
matured10310043ma_tured
maturer938983ma_turer
maturers1037383ma_turers
maturest1039703ma_turest
mixtures1735753mixtures
multures1039333multures
nature6311263na_ture_
natured838963na_tured
nurtures837443nurtures
papules112411573pap_ules
parures9512693pa_rures
pasture9311463pasture_
pastured1138233pastured
pasturer1037523pasturer
pasturers1136393pasturers
pictures1249343pictures
postures10313783postures
raptors94213353raptor_s
rapturous1144063rapturous
rasures7312013ra_sures
recapture1384713recapture_
recaptured1573593recaptured
rupture966163rupture_
ruptured1144683ruptured
saltires83112433saltires
santurs7310763santur_s
sapours93610623sapour_s
satires72617573sa_tires
sceptres1244993scept_res
scriptures1443793scriptures
sculptures1443843sculptures
statures83711113statures
sutures7314223_sutures
tartufes1164153tartufes
textures1597523textures
tortures838913tortures
upturns9264973_upturns
vapoured1434353vapoured
vapourer1344263vapourer
vapourers1443373vapourers
vapours12277463vapour_s
ventures11311493ventures
vestures11311043vestures
vultures1137213vultures
wafture1334853wafture_

Search took 9 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.406440125.6
2DLD Change Limit1461622057.62319173.8
3Display Results2052050.0802562.5
 (SQL Overall)1786912058.10922036.1
 
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.