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

114 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
houseless123747(None) 
horseless1237221horseless
causeless1135192causeless
fuseless11237232_fuseless
holeless1189362ho_leless
homeless131110142ho_meless
hopeless13118302ho_peless
housedress1443322housedress
houseled1237282housele_d
houseleek1643942houseleek
houseleeks1753062houseleeks
housels105312142housel__s
hueless1058822h_u_eless
noiseless945552noiseless
noseless839512no_seless
useless7188422__useless
baseless1099563_baseless
boneless10310213bo_neless
boughless1543873boughless
boundless1235183boundless
brushless1444003brushless
bushless1335813_bushless
ceaseless1135733ceaseless
clueless1035883clu_eless
codeless112010113co_deless
coreless103013833co_reless
corselets1147313corselets
costless10310003co_stless
counselees1244083counselees
countless1146373countless
crustless1155403crustless
cureless10319703_cureless
doubtless1243313doubtless
dustless9328353_dustless
focusless1452263focus_less
forceless1435723forceless
fumeless13236603_fumeless
gustless9287683_gustless
hideless12278713h_ideless
hiveless14227933h_iveless
hoarseness1345313hoarseness
hoodless12289733ho_odless
hoofless14258013ho_ofless
hookless151238363ho_okless
hoopless13279263ho_opless
hornless1137363ho_rnless
horseflesh1952193horseflesh
horsiness12259483horsiness
hosels94218613ho_sel__s
hostelers1246643hostelers
hostess103210243ho_s_tess
hostlers113310483ho_stlers
hourglass1341913hourglass
houseboys1744053houseboys
houseclean1562483houseclean
housecleans1662133housecleans
houseflies1644763houseflies
housefuls1544513housefuls
houseguest1473263houseguest
houseguests1581713houseguests
housekeep1853043housekeep
housekeeps1952653housekeeps
housekept1853803housekept
housel95217053housel___
houseling1337483houseling
houselled1346203houselled
housemen1346563houseme_n
housers104717823hous__ers
houses96032283hous__e_s
housesits1244853housesits
housetops1444373housetops
hugeness1237373h_ugeness
humpless15226333h_umpless
hurtless11307783h_urtless
hustlers11349203h_ustlers
hustles103414173h_ustle_s
issueless942393issueless
looseness937483looseness
lossless835473lo_ssless
lousiness9219043lousiness
loveless1168573lo_veless
menseless1145203menseless
mousiness11219033mousiness
mouthless1444713mouthless
moveless1367753mo_veless
noteless839403no_teless
nounless837253nou_nless
ousels64815283_ousel__s
outbless1037963_outbless
poleless1089873po_leless
popeless1288473po_peless
ruleless836633_ruleless
rustless83510243_rustless
senseless945973senseless
shoeless1137803sho__eless
shoreless1236633sho_reless
soleless8910033so_leless
soulless8218763sou_lless
soundless1035533soundless
soupless10268463sou_pless
sourceless1273013sourceless
toeless72612393to__eless
toneless8610393to_neless
tousles74113933tous_le_s
truceless11235393truceless
trustless955953trustless
tubeless1037023_tubeless
tuneless837913_tuneless
tuskless1234213_tuskless
voiceless1444223voiceless
voteless1137493vo_teless
woundless1334033woundless
yokeless1535303yo_keless
zoneless1737823zo_neless

Search took 10 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.440406115.9
2DLD Change Limit1486411148.93616634.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911149.42218965.3
 
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.