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

73 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
madhouse144550(None) 
madhouses1545741madhouses
baghouse1445212baghouse
beadhouse1544422beadhouse
cathouse1338862cathouse
gashouse1245692gashouse
roadhouse1344672roadhouse
taphouse1346332taphouse
ahorse9311513_a_horse
alehouse1146123alehouse
amadous1038503amad_ous_
arouse65019983_a_rouse
backhouse2046143backhouse
baghouses1545463baghouses
bakehouse18124583bakehouse
bathhouse1744193bathhouse
beadhouses1644293beadhouses
bedehouse1544073bedehouse
birdhouse1543703birdhouse
boathouse1445943boathouse
bughouse1445073bughouse
cachous14312583cachous_
carouse9614423ca_rouse
cathouses1439433cathouses
chouse116017563__chouse
doghouse1345413doghouse
douse66329723__d_ouse
farmhouse1744033farmhouse
funhouse1444523funhouse
gashouses1345763gashouses
gatehouse1345163gatehouse
guardhouse1552213guardhouse
henhouse1445573henhouse
hothouse1447353hothouse
house89131423___house
icehouse1344763icehouse
jailhouse1942823jailhouse
machoism1746393machoism
machos135217493macho_s_
madrone102812663madro_ne
madrones112912283madrones
madtoms1236923madtoms_
mahoe10315573ma_ho__e
mahoes11313103ma_hoes_
mahout11415803ma_hou_t
mahouts1237143ma_houts
maltose939783malto_se
manhole12311343manho_le
manholes13311183manholes
mannose939243manno_se
masseuse1044253masseuse
midcourse1442223midcourse
millhouse1443903millhouse
mouse77133003m___ouse
mudhole1344913mudho_le
mudholes1444873mudholes
nuthouse1145833nuthouse
oasthouse1244773oasthouse
outhouse11310883outhouse
playhouse1743933playhouse
pothouse1348703pothouse
redhorse1245463redhorse
rehouse10311773_rehouse
roadhouses1444503roadhouses
sadhus10298463sadh_us_
sawhorse1443523sawhorse
taphouses1446553taphouses
teahouse1146073teahouse
unhouse1038923_unhouse
vadose1037963vad_o_se
warehouse1545793warehouse
warhorse1445343warhorse
washhouse1843803washhouse

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.1561145455.1
2DLD Change Limit146162738.40617387.8
3Display Results73730.0332212.1
 (SQL Overall)178691738.59520790.1
 
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.