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

55 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
houseful144548(None) 
housefuls1544511housefuls
hopeful1545912ho_peful
housefly1744112housefly
housel95217052house__l
hushful1644332h_ushful
museful1245892_museful
useful947012__useful
blushful1643183blushful
boastful1344853boastful
doleful1146333do_leful
doubtful1442943doubtful
easeful1037293_easeful
forceful1644603forceful
hasteful14105253hasteful
hateful13107683h_ateful
hatsful13106193hats_ful
honeyful1743533honeyful
hopefuls1644073ho_pefuls
horsefly1744883horsefly
hosel86024823ho_se__l
house89131423house___
houseboy1643873houseboy
housecarl1453603housecarl
housed105624103house__d
household1644063household
houseled1237283houseled
housels105312143house_ls
houseman1346583houseman
housemen1346563housemen
houser95322283house__r
housers104717823house_rs
houses96032283house__s
housesat1146483housesat
housesit1177093housesit
housetop1343903housetop
hurtful1344853h_urtful
lustful1045283_lustful
menseful1344043menseful
moistful1343853moistful
mournful1342503mournful
mouthful1643573mouthful
ousel55222403_ouse__l
poutful1236743pou_tful
pushful1544493_pushful
rueful948203_ru_eful
senseful1144593senseful
soulful1045293sou_lful
sourceful1452353sourceful
thrustful1552273thrustful
trustful1144373trustful
tuneful1046123_tuneful
voiceful1643053voiceful
woeful1236363wo__eful
youthful1742973youthful

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.450397091.1
2DLD Change Limit146162558.28317646.0
3Display Results55550.0301833.3
 (SQL Overall)178691558.76320391.5
 
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.