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

149 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
hideous116843(None) 
hideout1179791hideout
hideouts1285571hideouts
hideously1644702hideously
hiders104919652hide_rs
hides95129432hide__s
hugeous1137132hugeous
hydrous14197882hydrous
niveous1037192niveous
piceous11310692piceous
pileous9510522pileous
piteous9310682piteous
timeous938402timeous
videos104911372video_s
wideout1179032wideout
wideouts1275232wideouts
adieus739633adie_us
adipous1037183adipous
aeneous739893aeneous
aiders74524633aide_rs
aides65336613aide__s
aqueous1636053aqueous
arduous837613arduous
biders94822803bide_rs
bides85536783bide__s
bidets95215533bide_ts
bijous1548043bi_jous
bilious9310933bilious
caseous9312513caseous
chiders135312943chide_rs
chides124620473chide__s
ciders94620093cide_rs
cinderous1247043cinderous
cineols9128853cineols
cirrous93111063cirrous
citreous1056853citreous
citrous93112993citrous
didoes85716963did_oes
didos76820823did_o_s
didymous1542913didymous
dimerous1139323dimerous
duteous838453duteous
eiders74321363eide_rs
eidos65817763eid_o_s
epigeous1146533epigeous
fadeout11410193fadeout
fadeouts1245693fadeouts
fibrous1237593fibrous
fidos95819063fid_o_s
gaseous839503gaseous
gibbous1265333gibbous
griseous945613griseous
hades96035113hade__s
hadrons113314303hadrons
heders104119763hede_rs
heinous1038853heinous
hiatus938223hi_atus
hide85134653hide___
hidebound1652333hidebound
hided105222453hide__d
hideless12278713hideless
hider95024093hide__r
hidings12349703hidings
hidroses1237903hidroses
hidrosis1246303hidrosis
hies74842843hi_e__s
hikers135014353hike_rs
hikes125426983hike__s
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
hilus84817643hi__lus
hinders113718503hinde_rs
hippos13408433hippo_s
hirees95117293hire_es
hirers94518063hire_rs
hires86134343hire__s
hives116925513hive__s
hoidens11329083hoide_ns
humerus1236923humerus
hydrops16197413hydrops
hydros13279363hydro_s
ideals75012503_ideals
ideas65919013_ide_as
ides57734243_ide__s
idioms956413_idioms
idiots768643_idiots
idols65514133_id_ols
idoneous944573_idoneous
igneous835773igneous
ileus54616893_ile_us
iodous7311503_iodous
kiddoes13387063kiddoes
kiddos12416873kiddo_s
libelous1047193libelous
lidos65219893lid_o_s
lieus56218483li_e_us
ligneous945233ligneous
luteous739273luteous
meous76120063__meous
miaous8511693mi_aous
mimeos104511543mimeo_s
nides65229143nide__s
nidus65913583nid__us
nimious937663nimious
niobous936333niobous
nitrous73512483nitrous
nodous7711333nod_ous
odeons739023_odeons
odious749933_odious
osseous736063osseous
pigeons1039183pigeons
pileus84514943pile_us
pilous84717753pi_lous
pious74621273pi__ous
pistous92714383pistous
riders74123903ride_rs
rides66140823ride__s
rimous8311913ri_mous
riotous739873riotous
rodeos75314503rodeo_s
sides65838373side__s
silenus7369693silenus
simious939803simious
sinuous739063sinuous
tedious838443tedious
tides64830163tide__s
timeout948593timeout
timeouts1044773timeouts
uveous936603_uveous
vicious1239493vicious
video96014963video__
villous102810023villous
vinous93914173vi_nous
viperous1347613viperous
vireos94212453vireo_s
viscous1238833viscous
vitreous1145843vitreous
vodous1038603vod_ous
whiteout1445583whiteout
whiteouts1543173whiteouts
widens106212723wide_ns
wides94832833wide__s
widgeons1343853widgeons
widows1376563wid_ows
wigeons1136983wigeons
wipeout1287873wipeout
wipeouts1354203wipeouts
zincous1837053zincous

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271498.73315347.2
3Display Results1491490.0502980.0
 (SQL Overall)1786911499.20619410.3
 
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.