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

120 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
cathouse133886(None) 
cathouses1439431cathouses
baghouse1445212baghouse
bathhouse1744192bathhouse
boathouse1445942boathouse
cachous14312582cachous_
carouse9614422ca_rouse
carthorse1446292carthorse
cathode1338992catho_de
cathodes1439392cathodes
chouse116017562c__house
gashouse1245692gashouse
gatehouse1345162gatehouse
hothouse1447352hothouse
madhouse1445502madhouse
nuthouse1145832nuthouse
oasthouse1244772oasthouse
outhouse11310882outhouse
pothouse1348702pothouse
taphouse1346332taphouse
acanthous1444423acanthous_
ahorse9311513_a_horse
alehouse1146123alehouse
arouse65019983_a_rouse
backhouse2046143backhouse
baghouses1545463baghouses
bakehouse18124583bakehouse
bathhouses1844193bathhouses
bathos116215633batho_s_
bathoses13310463batho_ses
beadhouse1544423beadhouse
boathouses1545923boathouses
bughouse1445073bughouse
caboose1138273ca_boose
cachou13310623cachou__
cahows14399123ca_hows_
callose9313663callo_se
callous93516603callous_
calloused1244403calloused
callouses1147683callouses
canthus1248713canth_us_
captious122810573captious_
carhops14329703carhops_
carious93320283carious_
caroused1149263ca_roused
carousel1057313ca_rousel
carouser1068853ca_rouser
carouses10614503ca_rouses
carrousel1174373carrousel
carthorses1546363carthorses
caseose939163caseo_se
caseous9312513caseous_
cashoos12310793cashoos_
catalase1039223catalase
catharses1446413catharses
cathexes2036273cathexes
cathodal14155413cathodal
cathodic16126753cathodic
catholic15158383catholic
cations94524143cations_
cause75225353ca___use
cautious103110233cautious_
cayuse11207763ca__yuse
choose115116143c__hoose
chophouse1945293chophouse
chose105925403c__ho_se
choused135012473c__housed
chouser125212943c__houser
chouses125117813c__houses
choush14549063c__housh
chowse144711753c__howse
citrous93112993citrous_
clubhouse1643183clubhouse
cookhouse1844933cookhouse
courthouse1543903courthouse
crouse84619373c__rouse
doghouse1345413doghouse
enthuse1046963enth_use
farmhouse1744033farmhouse
fathoms1537523fathoms_
fatuous1037783fatuous_
funhouse1444523funhouse
gashouses1345763gashouses
gatehouses1445263gatehouses
henhouse1445573henhouse
hothoused1644763hothoused
hothouses1547763hothouses
house89131423___house
icehouse1344763icehouse
jailhouse1942823jailhouse
kathode1545733katho_de
kathodes1646183kathodes
madhouses1545743madhouses
nuthouses1246343nuthouses
oasthouses1344973oasthouses
outhouses12310663outhouses
pathos115516693patho_s_
pathoses13412773patho_ses
penthouse1446273penthouse
pesthouse1445973pesthouse
playhouse1743933playhouse
pothouses1449043pothouses
rathole10312053ratho_le
ratholes11312413ratholes
rehouse10311773_rehouse
roadhouse1344673roadhouse
sawhorse1443523sawhorse
spathose1345633spatho_se
statehouse1353663statehouse
taphouses1446553taphouses
teahouse1146073teahouse
those85218143__tho_se
thous86017263__thous_
titmouse1043133titmouse
touse55430673__t_ouse
unhouse1038923_unhouse
warehouse1545793warehouse
warhorse1445353warhorse
washhouse1843803washhouse
xanthous1846643xanthous_

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.436409841.7
2DLD Change Limit1461621207.22020244.0
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.70223200.6
 
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.