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 “haoles” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
haoles9491980(None) 
hales85449841ha_les
haloes94623861haloes
haole84820081haole_
holes84748651h_oles
ables75935542_ables
aholds10469482aholds
ales47067102_a_les
aloes54933672_aloes
amoles84122192amoles
anoles64827432anoles
arles56735742_arles
axles125219472_axles
azoles154614612azoles
bales76250082ba_les
boles75448602_boles
cables104527552cables
cajoles163712102cajoles
carles85435082carles
caules85927252caules
chaoses124715122chaoses
coles76055062_coles
dales66439742da_les
dalles74222062dalles
dholes104914792dholes
doles67843752_doles
eagles73819162eagles
fables114921672fables
farles96025782farles
gables94222332gables
gales65442482ga_les
gaoled84814502gaoled
gaoler73913572gaoler
gaolers83511562gaolers
gaols66717572gaol_s
hackles162917062hackles
hades96035112ha_des
hadjes175210402hadjes
haeres94017032haeres
haes77651022ha__es
haggles123312482haggles
hailed104122742hailed
hailer94720342hailer
hailers104017262hailers
hails85231642hail_s
hajes155420942ha_jes
hajjes15485242hajjes
hakes126034302ha_kes
hale76052832ha_le_
haled95335822ha_led
haler85033522ha_ler
halers94926912ha_lers
halest94823272ha_lest
hallel93514092hallel
hallels103310132hallels
halloes104021522halloes
hallos95425102hallos
halls85633782ha_lls
halms105225212ha_lms
haloed104717602haloed
halons95720712halons
halos85230252ha_los
halts85230102ha_lts
halves124717092halves
hames106138702ha_mes
hamlet113722792hamlet
hamlets123211402hamlets
hances115621282hances
handles114020652handles
hanses95022632hanses
hantles104117512hantles
hapless123311332hapless
hares86255542ha_res
harls85634502harl_s
hashes125024802hashes
haslet93222712haslet
haslets102510862haslets
hassles103411692hassles
hastes95727072hastes
hates86742572ha_tes
hatless103813442hatless
hauled104415212hauled
hauler95015122hauler
haulers104012442haulers
haulms11558502haulms
hauls86123732haul_s
haves116034872ha_ves
hawses125113992hawses
hazels185710082hazels
hazes174928322ha_zes
hoaxes163611692hoaxes
hoes75755732h_o_es
hokes126231642h_okes
holds94623242h_olds
hole77553392h_ole_
holed95634132h_oled
holey115626902h_oley
holies94630032h_olies
holks124720562h_olks
holms105117802h_olms
hols76946292h_ol_s
holts85627912h_olts
homes106938812h_omes
hones88144492h_ones
hooves124815482hooves
hopes105835642h_opes
hoses85443172h_oses
howes114730262h_owes
hoyles12315012hoyles
joles125230832_joles
kales95730982ka_les
kayles134712002kayles
ladles74619542ladles
macles107023222macles
mailes84329112mailes
males75049792ma_les
maples104819422maples
moles74747922_moles
oboles83815832oboles
oles46453472__oles
padles95221122padles
pales75753802pa_les
parles86334402parles
paroles95025882paroles
poles75351002_poles
proles84627202proles
rales54947492ra_les
roles56747982_roles
sables85026692sables
sales56055592sa_les
shales94731252sha_les
soles55547922_soles
stoles63927672stoles
tables84524892tables
tales55451372ta_les
tholes94919782tholes
toles55147132_toles
vales85434262va_les
voles86234042_voles
wales86142832wa_les
whales124716942wha_les
wholes124616772wholes

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511422.20337472.1
3Display Results1421420.0463087.0
 (SQL Overall)1786911422.59268939.4
 
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.