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 “suberised” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
suberised129902(None) 
suberise10813931suberise_
suberises11813451suberises
suberized2198811suberized
soberized2197032soberized
subedited1345522subedited
suberize19812142suberize_
suberizes20811822suberizes
suberose10109692suberose_
submersed1445862submer_sed
supervised1646642supervised
surprised1245302surprised
berimed124912283__berimed
fiberized2444523fiberized
hubrises1337103hub_rises
obelised1136173_obelised
pulverised1643093pulverised
queried1738683qu_eri_ed
rubberized24143003rubberized
sabered103213023saber__ed
satirised1046543satirised
sclerosed1244013sclerosed
seised74218123s__e_ised
serifed11811463s__erifed
sobered102912433sober__ed
soberize1998883soberize_
soberizes2098963soberizes
sobersided1482313sobersided
solarised1068043solarised
solecised1285873solecised
subarid10310653subari__d
subbreed1345873subbr_eed
suberic11312213suberi__c
suberin9314563suberi__n
suberins10315093suberi_ns
suberising1347423suberising
subers85722643suber_s__
subjoined1944223subjoined
subleased1246123subleased
sublimed1337203sub_limed
submarined1544493submarined
submerged1544603submer_ged
submerse1237633submer_se_
submerses1348003submer_ses
suborned1137293subor_ned
subperiod1445633subperi_od
subscribed1743813subscribed
subseries11312933subseri_es
subserved1545143subser_ved
subsided1257643sub_sided
subsidised1443803subsidised
subsisted1245763sub_sisted
subsoiled1245433subsoiled
subtribe1246453subtribe_
subtribes1346223subtribes
suburbed1345143subur_bed
subverted1545443subver_ted
subwriter1445623subwriter
summarised15123913summarised
sunrise7310813su_nrise_
sunrises8310693su_nrises
supered10316123super__ed
superposed1546643superposed
supersede1269483super_sede
supersex1738423super_sex
supersized2247473supersized
supervise1449283supervise_
supervises1549073supervises
surmised1136853su_rmised
surprise1037673surprise_
surpriser1144603surpriser
surprises1137433surprises
surprized2144653surprized
tuberose1095323tuberose_
tuberoses1195363tuberoses
unerased9312773_unerased

Search took 10 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 Filter1786911486410.1701051123.5
2DLD Change Limit148641769.04616431.7
3Display Results76760.0332303.0
 (SQL Overall)178691769.24919320.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.