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

176 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
rapture93739(None) 
capture1138911capture
raptured1155471raptured
raptures1037581raptures
rupture966161rupture
captured1336572captured
capturer1246102capturer
captures1239442captures
enrapture1143262enrapture
facture12108942facture
fracture13147142fracture
mature8313472ma_ture
nature6311262na_ture
pasture9311462pasture
raptor83912822raptor_
raptors94213352raptors
rasure6311422ra_sure
recapture1384712recapture
ruptured1144682ruptured
ruptures1056682ruptures
wafture1334852wafture
abjure1536743_abjure
adjure1435843_adjure
allure63012943_allure
antre55224523_ant_re
aperture1046393_aperture
apter76120203_apter_
arcature1086503arcature
armature10106973armature
armure8710133_armure
assure6610773_assure
astute6310763_astute
attire62412383_attire
attune637983_attune
azure14911483_a_zure
baptise1139553baptise
baptize2036983baptize
battue84311003battu_e
bravure1254393bra_vure
capsule1137353capsule
captive1438973captive
captor104914603captor_
captors113914983captors
capturers1344633capturers
cloture9238453cloture
couture9310623couture
creature1038743creature
culture939393culture
dasyure1153823dasyure
datura738043da_tura
denture8311893denture
drawtube1441613drawtube
enraptured1352383enraptured
enraptures1243243enraptures
erasure736943era_sure
factures13129043factures
failure1035753failure
feature1039853feature
fixture1734963fixture
fractur12135573fractur_
fractured15125063fractured
fracturer14134643fracturer
fractures14147253fractures
fracturs13146323fracturs
fraktur14153043fraktur_
frakturs15163273frakturs
future939563_future
gesture839243gesture
gravure1134953gra_vure
gyplure13122013gyplure
hachure1545723hachure
haltere103614713haltere
haptene123810933haptene
impure1038383imp_ure
lecture9149523lecture
manure8313653ma_nure
matured10310043ma_tured
maturer938983ma_turer
matures9314313ma_tures
mixture1635413mixture
multure939183multure
natured838963na_tured
natures7311963na_tures
nurture736643nurture
papule102212133pap_ule
parure8312523pa_rure
pastured1138233pastured
pasturer1037523pasturer
pastures10311963pastures
picture1158613picture
posture9313253posture
pure65543333__p_ure
rafter94517583rafter_
raftered1237673raftered
rafters103715633rafters
ragtime1036163ragtime
ranter63826823ranter_
ranters73323643ranters
rape65041633rap___e
raper74932753rap_er_
rapers84327183rap_ers
raphae114311733rap_hae
raphe104916423rap__he
raphide13138073raphide
rapider1067903rapider
rapier84019993rapier_
rapiered1136053rapiered
rapiers95012873rapiers
rapine85023083rap_ine
rapparee1245873rapparee
rappee103618673rap_pee
rapper104621573rapper_
rappers113618443rappers
rapport11311223rapport
rapt67245313rapt___
raptly11338913rapt_ly
rapturing1245363rapturing
rapturous1144063rapturous
rare45348433ra___re
raster64731443raster_
rasters74629023rasters
rasures7312013ra_sures
rate45458763ra_t__e
rater54943283ra_ter_
raters63936583ra_ters
rathe85821923ra_t_he
rather94319743ra_ther
ratine65131823ra_tine
ratite65022423ra_tite
ratter64326313ratter_
ratters74422473ratters
rattier74015593rattier
rattle64717613ra_ttle
rattler74012743rattler
reassure847343reassure
recaptured1573593recaptured
recaptures1474463recaptures
renature839333renature
repour8310993repour_
repoured1139563repoured
repours9310233repours
reptile93914083reptile
repute84716093rep_ute
restore75822983restore
retire64927013r_etire
retore67630773r_etore
retune69121953r_etune
return623222523r_eturn
retuse66617223r_etuse
riptide1036893riptide
rondure837313rondure
saltire73113043saltire
santur6311273santur_
santurs7310763santurs
sapour83812383sapour_
sapours93610623sapours
satire63218003sa_tire
scripture1343883scripture
stature74410683stature
suture6313203_suture
tartare73012683tartare
tartufe1064673tartufe
texture1497083texture
torture738593torture
unpure82911533unp_ure
uptore8279453_uptore
upturn8286243_upturn
vapour11378873vapour_
vapoured1434353vapoured
vapourer1344263vapourer
vapours12277463vapours
vapoury15284803vapoury
venture10311173venture
vesture10310373vesture
vulture1036763vulture
waftures1434853waftures

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.420425454.8
2DLD Change Limit1340271767.45317983.0
3Display Results1761760.0802200.0
 (SQL Overall)1786911767.95322468.4
 
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.