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

156 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
houseled123728(None) 
houselled1346191houselled
counseled1245052counseled
hanseled1237712hanseled
hirseled12106252hirseled
hoseyed1436952ho_seyed
hosteled1237282hosteled
housed105624102hous__ed
housel95217042housel__
houseleek1643942houseleek
houseless1237462houseless
housels105312132housel_s
housemen1346562housemen
hoveled14209292ho_veled
hustled113210132h_ustled
morseled1147192morseled
tousled84710362tous_led
unhouseled1442062unhouseled
bobsled12297153bobs_led
boused95322883bous__ed
boweled132810693bo_weled
busheled1465263_busheled
bustled104011513_bustled
chiseled1435883chiseled
choused135012463chous__ed
consoled112911443consoled
corbeled1338373corbeled
corselet10414573corselet
corseted11311473corseted
cosseted1178343cosseted
counselee1145593counselee
counselled1344523counselled
coupled124312673cou_pled
cupeled1257793_cupeled
dieseled1035523dieseled
dogsled1035193dogs_led
doubled11289953dou_bled
doused84821163dous__ed
doweled12269773do_weled
dueled84813663_du_eled
easeled8159853_easeled
fouled104315973fou__led
foureyed1543663foureyed
fueled104913603_fu_eled
grueled937133gru_eled
handseled1444403handseled
hanselled1345473hanselled
hassled11358303h_assled
hauled104415213hau__led
hayseed1435633hayse_ed
heeled104018413h__eeled
hirselled1344683hirselled
hirsled11118113hirs_led
hoarsened1344053hoarsened
hobbled153310783ho_bbled
hocused13167013hocus__ed
hocussed14153793hocus_sed
hogweed1534443hogwe_ed
hoidened1335653hoidened
hoised105117433hois__ed
hoisted113411293hois_ted
holed95634133ho___led
hollered1237603hollered
holstered1345873holstered
homered133212713ho_mered
hondled123510653ho_ndled
honeyed1437773ho_neyed
hoovered15195413hoovered
hoppled15338083ho_ppled
horsed105321083hors__ed
horseless1237213horseless
horsemen1347483horsemen
horseweed1694663horseweed
hosed95830983ho_s__ed
hosel86024813ho_sel__
hosels94218603ho_sel_s
hosted105020343ho_s_ted
hosteler1137273hosteler
hostelled1345703hostelled
hostler103411023ho_stler
hounded123311033hou_nded
house89131423hous__e_
houseboy1643873houseboy
houseclean1562483houseclean
houseflies1644753houseflies
housefly1744103housefly
houseful1445473houseful
household1644053household
housekeep1853043housekeep
housekept1853803housekept
houseleeks1753053houseleeks
houseling1337483houseling
housemaid1543873housemaid
houseman1346573houseman
houser95322283hous__er
housers104717813house_rs
houses96032273hous__es
housesat1146473housesat
housesit1177093housesit
housetop1343903housetop
hovelled15146843hovelled
hovered143411573ho_vered
howled134014963ho__wled
hoydened1644643hoydened
huddled13349783h_uddled
hulled103920013h_u_lled
humbled153711813h_umbled
hurdled12379833h_urdled
hurled104617453h_u_rled
hurtled11339593h_urtled
hushed134416673h_us_hed
husked144212223h_us_ked
hustle93113993h_ustle_
hustler103410753h_ustler
hustles103414173h_ustles
jostled15267083jo_stled
jousted15339143jous_ted
justled15338093_justled
laureled934543laureled
loosened945453loosened
loudened1044693loudened
loused74822913lous__ed
louvered1244993louvered
modeled1139453mo_deled
morselled1245953morselled
moseyed1336133mo_seyed
moused94423303mous__ed
mousepad1343093mousepad
moussed10338913mous_sed
muscled1237783_muscled
ousel55222403_ousel__
ousels64815273_ousel_s
ousted73720583_ous_ted
outled74020343_ou_tled
pommeled1543103pommeled
roused75426443rous__ed
rousted84013323rous_ted
roweled11269863ro_weled
rustled83311323_rustled
shoveled15195353sho_veled
souffled15276183souffled
souled75419823sou__led
soused74822983sous__ed
tasseled935593tasseled
teaseled9186793teaseled
tinseled935763tinseled
toused74122013tous__ed
tousle64514653tous_le_
tousles74113933tous_les
touzled17367153tou_zled
toweled112410223to_weled
tussled835413_tussled
vesseled1243803vesseled
weaseled12175143weaseled
worsened1236053worsened
yodeled1236853yo_deled

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.1731032896.0
2DLD Change Limit1461621568.09618053.6
3Display Results1561560.0602600.0
 (SQL Overall)1786911568.32921454.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.