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

116 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
ruptures105668(None) 
raptures1037571raptures
rupture966161rupture_
ruptured1144681ruptured
captures1239442captures
cultures10310152cultures
futures10310262fu_tures
multures1039332multures
nurtures837442nurtures
rapture937382rapture_
raptured1155462raptured
sutures7314222su_tures
upturns9264972_upturns
vultures1137212vultures
arcatures1186833arcatures
armatures1166973armatures
capture1138913capture_
captured1336573captured
capturer1246093capturer
capturers1344633capturers
clotures10299023clotures
coutures10311993coutures
creatures1138413creatures
cubatures1344433cubatures
culture939393culture_
cultured1137233cultured
cultuses1037753cultuses
cupules113210263cup_ules
cutpurse1243133cutpurse
cutpurses1343313cutpurses
dentures9312453dentures
ductules1155543ductules
enraptures1243243enraptures
eruptives1443853eruptives
factures13129023factures
features11310333features
fixtures1835283fixtures
fractures14147233fractures
frustules1244663frustules
furfures1445663furfures
future939563fu_ture_
gestures9310013gestures
guipures1143733guipures
gyplures14102153gyplures
humitures1444303humitures
junctures1844033junctures
kulturs1134723kultur_s
lectures101310153lectures
lupuses936273lup_uses
lustres73013233lust_res
matures9314303_matures
mixtures1735753mixtures
multure939183multure_
mutules9311843mu_tules
natures7311963_natures
nurture736643nurture_
nurtured935253nurtured
nurturer844473nurturer
nurturers943353nurturers
outturns835913outturns
pastures10311963pastures
pictures1249343pictures
postures10313783postures
punctures1345343punctures
purpures1276143purpures
pustules1038443pustules
quatres163411933quat_res
raptors94213353raptor_s
rapturous1144053rapturous
rasures7312013r_asures
recaptures1474463recaptures
renatures939443renatures
repoured1139563repoured
repours9310233repour_s
reptiles103913063reptiles
reputes94615963rep_utes
restores85222993restores
retires74726213r_etires
retunes76918403r_etunes
returns79712593r_eturns
reuptakes1543213reuptakes
rictuses1037563rictuses
riptides1136413riptides
rondures937713rondures
ruckuses1444913ruckuses
rumoured1143783rumoured
rumours976373rumour_s
rumpuses1235163rumpuses
rupees8312573rup__ees
rupturing1244353rupturing
rustlers8339853rustlers
rustles73416413rust_les
rutiles74315843ru_tiles
scriptures1443793scriptures
sculptures1443843sculptures
statures83711113statures
structures1245453structures
suture6313203su_ture_
sutured8310373su_tured
textures1597523textures
tortures838913tortures
untunes72211253_untunes
upcurls1143653_upcurls
upcurves1583153_upcurves
upstares10178583_upstares
upsurges11144803_upsurges
uptakes1336593_uptakes
upthrew1542663_upthrew
uptimes1177553_uptimes
uptore8279453_uptore_
upturn8286243_uptur_n
upturned11214013_upturned
ventures11311493ventures
vestures11311043vestures
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 Filter1786911461620.406440125.6
2DLD Change Limit1461621167.21620255.3
3Display Results1161160.0502320.0
 (SQL Overall)1786911167.67223291.3
 
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.