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

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

84 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
whorehouses205333(None) 
whorehouse1953461whorehouse_
storehouses1453832storehouses
warehouses1645812w_arehouses
workhouses2044892w_orkhouses
chophouses2045143cho_phouses
choreguses1642973chore_guses
firehouses16135153_firehouses
horehounds1743403_horehounds
hothouses1547763_ho_thouses
poorhouses1545293poor_houses
rehouses11312113___rehouses
smokehouses2062203smokehouses
storehouse1343833storehouse_
warehouse1545793w_arehouse_
warehoused1743743w_arehoused
warehouser1643973w_arehouser
warehousers1752693w_arehousers
wheelhouses20102483wheelhouses
workhorses2043653w_orkhorses
workhouse1945253w_orkhouse_
alehouses1246584__alehouses
bakehouses19134454_bakehouses
barrelhouses1751584barrelhouses
bedehouses1644094_bedehouses
birdhouses1643324_birdhouses
blockhouses2252504blockhouses
boathouses1545924_boathouses
boreholes1447354_boreho_les
chophouse1945294cho_phouse_
choraguses1642544chor_aguses
choruses1339984chor___uses
cookhouses1944604_cookhouses
courthouses1653964courthouses
doghouses1445354_do_ghouses
dollhouses1444054_dollhouses
dosshouses1443584_dosshouses
farmhouses1844014_farmhouses
firehouse15135534_firehouse_
flophouses1853964flo_phouses
forehooves1963584_forehooves
gatehouses1445264_gatehouses
guardhouses1662114guardhouses
henhouses1546174_h_enhouses
horehound1644704_horehou_nd
hothouse1447354_ho_thouse_
hothoused1644764_ho_thoused
icehouses1445014__icehouses
longhouses1444984_longhouses
morphoses1648124_morpho_ses
orthoses11311134__ortho_ses
outhouses12310664__outhouses
phoebuses1643214pho_e_buses
phosphoruses2253844phosphoruses
poorhouse1445314poor_house_
porterhouses1752644_porterhouses
pothouses1449044_po_thouses
powerhouses1952474_powerhouses
rehouse10311774___rehouse_
rehoused1239614___rehoused
roadhouses1444504_roadhouses
schoolhouses2052054schoolhouses
smokehouse1982374smokehouse_
statehouses1453764statehouses
tollhouses1344554_tollhouses
toolhouses1344574_toolhouses
townhouses1653854_townhouses
treehouses1345194_treehouses
vitreouses1343004vitre_ouses
warhorses1545574w_ar_horses
washhouses1943504w_ashhouses
wellhouses1643784w_ellhouses
wheelhorses20111974wheelhorses
wheelhouse19102574wheelhouse_
whereases1545674where__ases
wherefores1983394wherefo_res
wholenesses1745804wholenesses
whoredoms1843364whoredo__ms
whoremonger2052234whoremonger
whoremongers2162044whoremongers
whoresons1543864whoreso__ns
workhorse1943854w_orkhorse_
workhours1943194w_orkhou_rs
wormholes1744614w_ormho_les

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 Filter1786911488190.440406115.9
2DLD Change Limit148819848.14018282.4
3Display Results84840.0461826.1
 (SQL Overall)178691848.62620715.4
 
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.