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

113 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
cathouses143943(None) 
cathouse1338861cathouse_
baghouses1545462baghouses
bathhouses1844192bathhouses
bathoses13310462batho_ses
boathouses1545922boathouses
callouses1147682callouses
carouses10614502ca_rouses
carthorses1546362carthorses
catharses1446412catharses
cathodes1439392catho_des
chouses125117812c__houses
gashouses1345762gashouses
gatehouses1445262gatehouses
hothouses1547762hothouses
madhouses1545742madhouses
nuthouses1246342nuthouses
oasthouses1344972oasthouses
outhouses12310662outhouses
pathoses13412772patho_ses
pothouses1449042pothouses
taphouses1446552taphouses
acanthuses1552643acanth_uses
alehouses1246583alehouses
arouses74921293_a_rouses
backhouses2145743backhouses
baghouse1445213baghouse_
bakehouses19134453bakehouses
bathhouse1744193bathhouse_
beadhouses1644293beadhouses
boathouse1445943boathouse_
bughouses1544743bughouses
cabooses1237863ca_booses
cachous14312583cachou__s
cactuses1237933ca_ctuses
caestuses1144893caestuses
calloses10313393callo_ses
calloused1244403calloused
calluses1039323ca_lluses
campuses1437773ca_mpuses
caroluses1157613caroluses
carouse9614423ca_rouse_
caroused1149253ca_roused
carousel1057313ca_rousel
carousels1165343ca_rousels
carouser1068853ca_rouser
carousers1156743ca_rousers
carrousel1174373carrousel
carrousels1253263carrousels
carthorse1446293carthorse_
caryopses1645043caryopses
caseoses1039293caseo_ses
catalases1149443catalases
catalyses1447433catalyses
catharsis1444483catharsis
cathexes2036273cath_exes
cathode1338993catho_de_
catholics16105893catholics
caucuses1236783ca_ucuses
causes88026473ca___uses
cayuses12188403ca__yuses
chooses125717423c__hooses
chophouses2045143chophouses
choruses1339983c__horuses
choses115825133c__ho_ses
chouse116017563c__house_
choused135012463c__housed
chouser125212943c__houser
chousers134610203c__housers
choushes1637623c__houshes
chowses155611283c__howses
citruses1037483cit_ruses
clubhouses1742843clubhouses
cookhouses1944603cookhouses
courthouses1653953courthouses
doghouses1445353doghouses
enthuses1138253enth_uses
ethoses10311763_etho_ses
farmhouses1844013farmhouses
funhouses1544593funhouses
gashouse1245693gashouse_
gatehouse1345163gatehouse_
henhouses1546173henhouses
hothouse1447353hothouse_
hothoused1644763hothoused
houses96032273___houses
icehouses1445013icehouses
isthmuses1442973isthmuses
jailhouses2043003jailhouses
katharses1643873katharses
kathodes1646183katho_des
madhouse1445503madhouse_
nuthouse1145833nuthouse_
oasthouse1244773oasthouse_
orthoses11311133ortho_ses
outhouse11310883outhouse_
penthouses1546613penthouses
pesthouses1546243pesthouses
playhouses1843873playhouses
pothouse1348703pothouse_
ratholes11312413ratho_les
rehouses11312113_rehouses
roadhouses1444503roadhouses
sawhorses1543753sawhorses
scabiouses1443003scabiouses
statehouses1453763statehouses
taphouse1346333taphouse_
teahouses1246513teahouses
touses64229673__t_ouses
unhouses1138703_unhouses
warehouses1645813warehouses
warhorses1545573warhorses
washhouses1943503washhouses

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411137.44019978.6
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.90622601.9
 
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.