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

128 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
obtained113653(None) 
obtainer1045791obtainer
abstained1245052abstained
attained997352attained
bobtailed1443192bobtailed
brained103816102_brained
contained12310892contained
detained103111642detained
obtain839182obtain__
obtainers1144852obtainers
obtains939162obtain_s
ordained1035182ordained
outgained1137222outgained
outlined92512952outlined
reobtained1343392reobtained
retained93016092retained
stained84215342_stained
abstainer1144403abstainer
attainer8116913attainer
attainted1044693attainted
bailed94726653_b_ailed
baited95319243_b_aited
baned85436353_b_a_ned
banned94721343_b_anned
barned95623583_b_arned
basined10310003_basined
batiked1435963_batiked
beaned95621473_bea_ned
betaine9413783betaine_
betaines10313293betaines
botanies10312853botanies
botanised1246393botanised
botanized2147283botanized
braided114013213_braided
brailed103914013_brailed
braised104014803_braised
branned104311693_branned
brined95118413_b_rined
bylined1335853_bylined
captained1446193captained
chained133812693_chained
container11311073container
curtained1265503curtained
destained1158253destained
detailed10319873detailed
detainee92511723detainee
detainer92910793detainer
detrained1158913detrained
distained1139603distained
drained93713253_drained
entailed989523entailed
entrained1089413entrained
entwined1235843entwined
fountained1443333fountained
gained84617463__gained
grained93814273_grained
hobnailed1542253hobnailed
intwined1235463intwined
mutined103311353mut_ined
obelised1136173obelised
obelized2036333obelized
obliged1134983ob_liged
obtaining1236773obtaining
obtainment1454313obtainment
obtected1344553obtected
obtested1135453obtested
obtruded1243363obtruded
obtund945583obt_un_d
obtunded1243523obtunded
obviated1444563obviated
octane81411633octa_ne_
octanes91111393octa_nes
opined95113853o__pined
optioned1146383optioned
ordainer945223ordainer
outacted1139383outacted
outadded1135933outadded
outasked1337123outasked
outearned1056683outearned
outfawned1644133outfawned
outfind1139563outfin_d
outfired1238083outfired
outjinxed2443133outjinxed
outline72321333outline_
outliner82412113outliner
outlines82418093outlines
outlived12269583outlived
outmanned1245483outmanned
outpainted1344323outpainted
outraised1039243outraised
outsailed1037793outsailed
outshined1346543outshined
outsinned1045673outsinned
outsized18209743outsized
outvied11239693outvi_ed
outwaited13137293outwaited
outwiled1237603outwiled
outwind1139153outwin_d
outwinded1444663outwinded
pained95622853__pained
patined105114783pat_ined
pertained1238503pertained
plained103812233_plained
preobtained1652763preobtained
rained75024603__rained
regained102111243regained
remained112412893remained
retailed94113963retailed
retainer82913813retainer
retrained10411313retrained
sained75424243__sained
sprained1138433sprained
stainer73614923_stainer
staned74824643_sta_ned
strained9412253strained
sustained1045383sustained
tailed74424663__tailed
tainted83512423__tainted
tanned75219953__tanned
tined65434533__t_ined
trained84117203_trained
trined74920713__trined
twined104413123__twined
unstained1038683unstained
untainted1038423untainted
untanned9279963untanned
untrained10510993untrained
untwined1237063untwined

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 Limit1461621287.56319325.9
3Display Results1281280.0462782.6
 (SQL Overall)1786911288.01522294.6
 
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.