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

155 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
hatbox183513(None) 
hotbox1835691hotbox
batboy1387532batboy
harbor11410722harbor
hatboxes2055002hatboxes
hautboy1553422hautboy
outbox1537452outbox
saltbox1643742saltbox
abbot9318453_abbot
abo59045963_a_bo_
abos67734413_a_bos
ambo88225143_ambo_
ambos95321253_ambos
arbor74818113_arbor
atom67824523_at_om
atop66124753_at_op
baboo94319503ba_boo
balboa10389963balboa
bamboo12310013bamboo
bandbox1943763bandbox
batboys1465833batboys
bathos116215633bathos
baton75822423bat_on
box1210142343___box
cabob114616813ca_bob
carbo94923843carbo_
carbon104919043carbon
carbos105122263carbos
carboy134914183carboy
cashbox2143453cashbox
catboat11412243catboat
cation83925503cation
chaebol1444943chaebol
coalbox1844103coalbox
dato56129943dat_o_
datos65222783dat_os
datto65416423datto_
dattos74311903dattos
detox13310953det_ox
farebox1943823farebox
fathom1437473fathom
fatso85113493fatso_
fatsos9389423fatsos
gambol1138223gambol
gator64416033gat_or
gearbox1742953gearbox
habit103027023ha_bit
haboob1377883haboob
habu97325483ha_b_u
habus106317143ha_bus
hadron102913753hadron
hagborn1344953hagborn
hagbut1278913hagbut
hagdon1188283hagdon
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
hallux1637363hallux
halo76437323ha_lo_
halon86124863ha_lon
halos85230253ha_los
hambone1439313hambone
handax1749583handax
hansom11219153hansom
hao67251123ha__o_
hapax1739323ha_pax
harbors12412413harbors
harbour1247053harbour
harlot94422803harlot
harrow122610773harrow
hat67289963hat___
hatable121713963hatable
hatband1346823hatband
hatch135719593hat_ch
hate78450173hat__e
hated95734023hat_ed
hater85034753hat_er
haters94930393haters
hates86742573hat_es
hatful12108743hatful
hath105933913hat__h
hating104929713hating
hatpin112610603hatpin
hatred104814333hatred
hats76858253hat__s
hatted104921513hatted
hatter94724873hatter
hautbois1343103hautbois
hautboys1642773hautboys
havior1248203havior
havoc1337183ha_voc
haymow1773683haymow
hellbox1944983hellbox
hobo97026083h_obo_
hobos106321353h_obos
hotbed123310673hotbed
hotboxes2045063hotboxes
hotdog1134793hotdog
hotrod1048793hotrod
icebox1753083icebox
jabot14321513ja_bot
jato115822683jat_o_
jatos125116823jat_os
kabob134113933ka_bob
kation104315683kation
labor75117313la_bor
latex124717113lat_ex
mailbox1853563mailbox
mambo115215743mambo_
mambos125414493mambos
matchbox2442623matchbox
matrix1539833matrix
matron83918313matron
matzo16312893matzo_
matzoh2035483matzoh
matzos1749263matzos
matzot17710983matzot
nabob93913743na_bob
nation64322803nation
natron64116023natron
outfox1636133outfox
pathos115516693pathos
patio74426353patio_
patios85221783patios
patrol83213023patrol
patron84018043patron
pegbox1844013pegbox
postbox1885493postbox
potboy1397813potboy
ratbag956563ratbag
ratio55227583ratio_
ration64226013ration
ratios64922673ratios
rato45436973rat_o_
ratoon64417373ratoon
ratos55528763rat_os
ratton64116123ratton
sabot7931773sa_bot
sambo95118013sambo_
sambos104315193sambos
sandbox1744803sandbox
shoebox1943613shoebox
skybox2242293skybox
soapbox1843123soapbox
sweatbox2041543sweatbox
taboo73418093ta_boo
tabor75518393ta_bor
tatsoi637263tatsoi
tattoo6310973tattoo
teabox1536013teabox
unbox1438753_unbox
whatnot1344733whatnot

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161558.11013898.4
3Display Results1551550.0433604.7
 (SQL Overall)1786911558.29621539.4
 
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.