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

101 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
ruptured114468(None) 
raptured1155471raptured
rupture966161rupture_
ruptures1056681ruptures
captured1336572captured
cultured1137232cultured
nurtured935262nurtured
rapture937392rapture_
raptures1037582raptures
repoured1139562repoured
rumoured1143782rumoured
sutured8310372su_tured
upturned11214012_upturned
armatured1264623armatured
augured987193au_gured
buttered112712633buttered
capture1138913capture_
capturer1246103capturer
captures1239443captures
clotured11246163clotured
culture939393culture_
cultures10310153cultures
enraptured1352383enraptured
erupted10207173erupt__ed
featured1237683featured
fractured15125063fractured
future939563fu_ture_
futures10310263fu_tures
gestured1036993gestured
guttered10259173guttered
humoured1444363humoured
inpoured1135813inpoured
lectured11127233lectured
lustered92510613lustered
lustred8359053lust_red
matured10310043_matured
multure939183multure_
multures1039333multures
murmured1343113murmured
mustered112511513mustered
muttered112610803muttered
natured838963_natured
nurture736643nurture_
nurturer844473nurturer
nurtures837443nurtures
outbred10311263ou_tbred
outpoured1246013outpoured
pastured1138233pastured
pictured1346573pictured
postured1139493postured
poured95116743__poured
punctured1444183punctured
pustuled1134953pustuled
puttered112611153puttered
raftered1237673raftered
rapiered1136053rapiered
recaptured1573593recaptured
renatured1047293renatured
repaired1148953repaired
reputed104613483rep_uted
restored96417193restored
retired84620143r_etired
retuned86613973r_etuned
returned9459133r_eturned
reuttered1036073reuttered
rubbered1335383rubbered
rumored1046643ru_mored
rupturing1244353rupturing
rusted75020923rust__ed
rustled83311323rust_led
rutted74518403ru_t_ted
sculptured1542743sculptured
structured1343993structured
sulfured1236113sulfured
sulphured1542923sulphured
supered10316123sup_ered
suture6313203su_ture_
sutures7314223su_tures
textured1695483textured
tortured935843tortured
tutored837553tu_tored
tutued7349413tu_tu_ed
uncured10513233_uncured
untired82316383_untired
untuned82010823_untuned
unturned9228563_unturned
upcurled1393783_upcurled
upcurved16142993_upcurved
upstared11156573_upstared
upsurged12124043_upsurged
upthrew1542663_upthrew
uptore8279453_uptore_
uptrend1044293_upt_rend
upturn8286243_uptur_n
upturns9264973_upturns
uttered82712443_uttered
vapoured1434353vapoured
ventured1238273ventured
vestured1237463vestured
vulture1036763vulture_
vultures1137213vultures

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.423422437.4
2DLD Change Limit1461621018.40617387.8
3Display Results1011010.0303366.7
 (SQL Overall)1786911018.85920170.6
 
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.