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

119 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
horseless123721(None) 
houseless1237461houseless
coreless103013832cor_eless
corselets1147312corselets
forceless1435722forceless
hoarseness1345302hoarseness
holeless1189362ho_leless
homeless131110132ho_meless
hopeless13118302ho_peless
hornless1137362hor_nless
horseflesh1952192horseflesh
horsiness12259472horsiness
noiseless945552noiseless
noseless839512no_seless
shoreless1236632shor_eless
baseless1099563_baseless
boneless10310213bo_neless
careless102813633car_eless
causeless1135193causeless
ceaseless1135733ceaseless
coarseness1246173coarseness
codeless112010113co_deless
cordless11299963cor_dless
corselet10414573corsele_t
corslets1038273cors_lets
costless10310003co_stless
cureless10319703cur_eless
dorsels84412573dorsel__s
fireless112810593fir_eless
fordless12289003for_dless
forelegs1236613for_elegs
forkless15267433for_kless
formless13248083for_mless
frostless1235743frostless
fuseless11237233_fuseless
gormless11235443gor_mless
groveless13235363groveless
harmless1337403har_mless
harshness1545963harshness
harslets1137833hars_lets
herbless1336663her_bless
hideless12278713h_ideless
hirseled12106253hirsele_d
hirsels10128343hirsel__s
hirsles101510073hirs_le_s
hiveless14227933h_iveless
hoodless12289733ho_odless
hoofless14258013ho_ofless
hookless151238363ho_okless
hoopless13279263ho_opless
hornedness1445403hornedness
horniness12309143horniness
horsebean1473753horsebean
horsebeans1583623horsebeans
horsecars1444763horsecars
horsefleshes2151333horsefleshes
horseflies1644713horseflies
horselike1646263horselike
horsemen1347483horseme_n
horseplays1842803horseplays
horses94729343hors__e_s
horseweed1694663horseweed
horseweeds17113483horseweeds
horsiest112513263hors_iest
horstes104516113hors_te_s
hosels94218603ho_sel__s
hostelers1246633hostelers
hostess103210243ho_s_tess
hostlers113310483ho_stlers
housedress1443313housedress
houseled1237283housele_d
houseleek1643943houseleek
houseleeks1753053houseleeks
housels105312133housel__s
hueless1058823h__ueless
hurtless11307783hur_tless
ireless72312243_ir_eless
looseness937473looseness
lordless9277483lor_dless
lossless835473lo_ssless
loveless1168573lo_veless
menseless1145203menseless
moreness10911573mor_eness
moroseness1246213moroseness
morseled1147193morsele_d
morsels94112653morsel__s
moveless1367753mo_veless
nerveless1243933nerveless
normless10235923nor_mless
noteless839403no_teless
orbless937493_or_bless
orderless1044313_orderless
poleless1089873po_leless
popeless1288473po_peless
porteress1137933porteress
portless10310643por_tless
remorseless1371963remorseless
scoreless1155603scor_eless
senseless945973senseless
shoeless1137803sho__eless
soleless8910033so_leless
sorceress1144013sorceress
soreness8914793sor_eness
sourceless1273013sourceless
terseness948403terseness
thornless1243633thor_nless
tireless82510263tir_eless
toeless72612393to__eless
toneless8610393to_neless
treeless839283_treeless
useless7188423__useless
voiceless1444223voiceless
voteless1137493vo_teless
wireless11249633wir_eless
wordless12258843wor_dless
workless15276803wor_kless
worthless1544923worthless
yokeless1535303yo_keless
zoneless1737823zo_neless

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.423422437.4
2DLD Change Limit1486411196.54622707.1
3Display Results1191190.0631888.9
 (SQL Overall)1786911197.03225411.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.