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

123 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
outhouse1131088(None) 
nuthouse1145831nuthouse
outhouses12310661outhouses
boathouse1445942boathouse
bughouse1445072bughouse
cathouse1338862cathouse
courthouse1543902courthouse
funhouse1444522funhouse
hothouse1447352hothouse
nuthouses1246342nuthouses
oasthouse1244772oasthouse
pothouse1348702pothouse
unhouse1038922_unhouse
alehouse1146123alehouse
authorise1248023authorise
authors10311853authors_
baghouse1445213baghouse
bathhouse1744193bathhouse
boathouses1545923boathouses
bughouses1544743bughouses
bunkhouse18123653bunkhouse
cathouses1439433cathouses
chouse116017563__chouse
clubhouse1643183clubhouse
cookhouse1844933cookhouse
courthouses1653963courthouses
doghouse1345413doghouse
dollhouse1344053dollhouse
dosshouse1343713dosshouse
duteous838453duteous_
enthuse1046963enth_use
funhouses1544593funhouses
gashouse1245693gashouse
gatehouse1345163gatehouse
henhouse1445573henhouse
hothoused1644763hothoused
hothouses1547763hothouses
house89131423___house
icehouse1344763icehouse
longhouse1345403longhouse
luteous739273luteous_
madhouse1445503madhouse
oasthouses1344973oasthouses
obtuse8147483obt__use
orthoses11311133ortho_ses
otiose639403o_tio_se
outblush1343753outblush
outboast1048543outboast
outbound1146583outbound
outboxes1737823outboxes
outcome11310573outco_me
outcomes1239763outcomes
outcount1049143outcount
outcurse1045833outcurse
outdodge1143773outdodge
outdoes8313123outdoes_
outdone8311643outdo_ne
outfound1245763outfound
outfoxes1836743outfoxes
outgoes8312643outgoes_
outgone8311463outgo_ne
outgush1145133out_gush
outhaul1039063outhau_l
outhauls1137223outhauls
outhits102213503outhits_
outhomer1348133outhomer
outhowl1337203outho_wl
outhowled1645103outhowled
outhowls1445723outhowls
outhunt10311043outh_unt
outhustle1253053outh_ustle
outlove102410243outlo_ve
outloves11249673outloves
outmode10199663outmo_de
outmodes11208963outmodes
outmost9511213outmo_st
outmove12238713outmo_ve
outmoves13228173outmoves
outpost9612443outpo_st
outpour937423outpou_r
outpoured1246013outpoured
outpourer1144163outpourer
outpours1036683outpours
outpush1245493out_push
outquote1775293outquote
outraise8311933outraise
outrode82313423outro_de
outrows10311403outrows_
outrush1037043out_rush
outshone1149343outsho_ne
outshout1149493outshou_t
outshouted1443903outshouted
outshouts1245213outshouts
outsole71013433outso_le
outsoles8813113outsoles
outsource1143403outsource
outthrust1243643outthrust
outvoice1344793outvoice
outvote1038803outvo_te
outvotes1137903outvotes
outwore101912693outwo_re
penthouse1446273penthouse
pesthouse1445973pesthouse
poorhouse1445313poorhouse
pothouses1449043pothouses
rehouse10311773_rehouse
roadhouse1344673roadhouse
roughhouse1752323roughhouse
roundhouse1472923roundhouse
taphouse1346333taphouse
teahouse1146073teahouse
those85218143__tho_se
thous86017263__thous_
titmouse1043133titmouse
tollhouse1244543tollhouse
toolhouse1244693toolhouse
touse55430673__t_ouse
townhouse1544283townhouse
unhorse1038583_unhorse
unhoused1238153_unhoused
unhouses1138703_unhouses
uprouse937223_uprouse
workhouse1945253workhouse

Search took 7 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.406440125.6
2DLD Change Limit1461621236.23323449.7
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.68526730.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.