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

80 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
sabulous104612(None) 
fabulous1344851fabulous
bibulous1244632bibulous
hamulous1344922hamulous
nebulous1045092nebulous
patulous10116362patulous
ramulous1045882ramulous
sabulose1044612sabulose
sedulous946132sedulous
setulous846912setulous
tubulous1045362tubulous
abulias93210693_abulias
acaulous1045923acaulous
aculeus937513_aculeus
angulous946213angulous
anurous7311553_anurous
aqueous1636053_aqueous
aurous64119263_a_urous
babuls105413643babul__s
bulbous1138293__bulbous
bullous9311663__bullous
caducous1344363caducous
calculous1344793calculous
callous93516603ca_llous
crapulous1343963crapulous
cumulous1245273cumulous
emulous937343_emulous
fabulously1853323fabulously
famulus1235043famul_us
fatuous1037783fatu_ous
gallous82813953ga_llous
garrulous1043313garrulous
hamulus1235323hamul_us
kabeljous2251663kabeljous
libelous1047193libelous
nodulous944733nodulous
nubilous1044833nubilous
orgulous944203orgulous
pabulum1344473pabul_um
pabulums1443003pabulums
parlous9414293pa_rlous
populous1245953populous
raucous938283ra_ucous
sabals84618863sabal__s
sabatons1037843sabatons
sabayons1343963sabayons
sables85026693sab_l_es
sabots8314693sab__ots
sacculus1244813saccul_us
sailors73213713sa_ilors
sajous13310583sa__jous
sallows103915543sa_llows
salols64017873sa__lols
salons63823683sa__lons
sandlots938293sandlots
sanious7514103sa_nious
sapajous1744833sapajous
saporous1039053saporous
sarcous9312933sa_rcous
sauls55128123sa_ul__s
saults65816173sa_ul_ts
saveloys1444013saveloys
savorous1146603savorous
sawlogs1135393sa_wlogs
scabious1246593scab_ious
scabrous1245993scab_rous
sepalous1047523sepalous
sinuous739063sinu_ous
soukous1136403s_oukous
spumous1135853s_pumous
strumous1045723strumous
suberous10311783suberous
sublots92410913sub_lots
subplots1255773subplots
sulcus8410493s__ulcus
sulus54821883s__ul_us
tabulis938833tabul_is
tumulous1045293tumulous
vacuous1237023vacu_ous
venulous1145713venulous

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.1561145455.1
2DLD Change Limit146162807.11020557.2
3Display Results80800.0302666.7
 (SQL Overall)178691807.29624491.6
 
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.