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

144 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
hambones153967(None) 
ambones11312681_ambones
hambone1439311hambone_
hamboned1637001hamboned
gamboges1435652gamboges
hatboxes2055002hatboxes
hipbones1546022hipbones
jawbones20134852jawbones
mamboes135011822mambo_es
sawbones13126642sawbones
umbones1138012_umbones
abodes94417513_a_bodes
aboves114512843_a_boves
agones75719863_a_gones
amarones10311353_amarones
ambages1269623_ambages
ambles105121863_amb_les
amboinas1246033_amboinas
ambos95321253_ambo__s
amboynas1543233_amboynas
ambries111614553_ambries
amidones11348663_amidones
amines84727983_am_ines
ammines11312673_ammines
amoles84122193_am_oles
ancones93116343_ancones
arbores94016033_arbores
atones65225773_a_tones
axones134614513_a_xones
backbones1947253backbones
bambinos1443873bambinos
bamboos1348753bambo_os
bimboes13498733bimbo_es
bones76446533___bones
cajones163311333ca_jones
calzones1948763calzones
camions113916133camion_s
campongs15356123campongs
canzones1939153canzones
carbines123617533carbines
carbons115418943carbon_s
chalones13312173cha_lones
chinbones1655033chinbones
combines142814623combines
cramboes1436543crambo_es
daemones11209163daemones
daimones11208803daimones
damsons1038013damson_s
dapsones1138383dapsones
debones103315113_debones
famines123216263fam_ines
gambades1435863gambades
gambes116318313gamb__es
gambles124016203gamb_les
gamboge1335583gamboge_
gamboled1435873gamboled
gambols1238593gambo_ls
gamines103618463gam_ines
gammoned1444993gammoned
gammoner1345153gammoner
gammoners1444563gammoners
gammons1237973gammon_s
haboobs1495463ha_boobs
hadrons113314303hadron_s
hagdons1258523hagdon_s
halazones2145993halazones
halftones1545213halftones
halloes104021523hallo_es
haloes94623863ha_lo_es
halons95720713ha_lon_s
hamates122917683ham_ates
hamboning1745893hamboning
hamburgs1643473hamburgs
hames106138703ham___es
hamminess1635713hamminess
hammocks2164343hammocks
haoles94919803ha__oles
haplonts1345773haplonts
haploses1338853haploses
haptenes133810823haptenes
harbored1438633harbored
harborer1348053harborer
harborers1446913harborers
harbors12412413harbo_rs
harbours1346923harbours
harmines132715143harmines
harmonies141311043harmonies
hatbands1446293hatbands
hemlines13310623hemlines
henbanes1336573henbanes
hexones17299143h_exones
hipbone1445923hipbone_
histones11312803histones
hoboes114717443h_obo_es
hombres14369873homb_res
homines123518643hom_ines
hommoses1538153hommoses
hones88144493h___ones
hormones13311163hormones
hotboxes2045063hotboxes
humbles143215803humb_les
iambuses1235783iambuses
impones112712253_impones
jambes175914053jamb__es
jamboree1944863jamboree
jamborees2043273jamborees
jawbone19134443jawbone_
jawboned21133553jawboned
jawboner20133363jawboner
jawboners21133053jawboners
kampongs17293033kampongs
lactones10311223lactones
ladrones92710973ladrones
lambies113015113lamb_ies
lazybones2342273lazybones
madrones112912283madrones
mamboed14417623mambo_ed
mambos125414493mambo__s
mammons1048513mammon_s
padrones112711043padrones
pinbones1238143pinbones
rabbonis1245013rabbonis
rambles113118313ramb_les
ramonas9311093ram_onas
rampoles1238893rampoles
ramsons939563ramson_s
rawboned14114253rawboned
redbones1137593redbones
rhamnoses14104183rhamnoses
sabines94318483sa_bines
sambos104315193sambo__s
sambukes1644193sambukes
shambles15159043shamb_les
shinbones1454583shinbones
someones1039063someones
tailbones1155263tailbones
tambours1255873tambours
tamponed1336023tamponed
tampons112711563tampon_s
trombones1345363trombones
vamooses1345523vamooses
vamoses1239143vam_oses
wambles143714023wamb_les
whalebones1853323whalebones

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.420425454.8
2DLD Change Limit1461621446.20323563.1
3Display Results1441440.0632285.7
 (SQL Overall)1786911446.68626726.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.