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

134 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
haole8482008(None) 
hale76052831ha_le
haoles94919801haoles
hole77553391h_ole
able66340532_able
ahold94714252ahold
ale36572342_a_le
aloe45540192_aloe
amole75724592amole
anole55330382anole
axle116424602_axle
azole145118032azole
bale66353842ba_le
bole66448692_bole
cable95329912cable
cajole154011182cajole
carle74535702carle
cole66956112_cole
dale55643982da_le
dhole95215362dhole
dole56550002_dole
eagle64219482eagle
fable105824752fable
farle86929242farle
gable85325522gable
gale56347322ga_le
gaol56925412gaol_
gaoled84814502gaoled
gaoler73913572gaoler
gaols66717572gaols
habile11515212habile
hackle154916812hackle
hade85440202ha_de
hae67364002ha__e
haggle113511982haggle
hail74839062hail_
hailed104122742hailed
hailer94720342hailer
hails85231642hails
hake115637842ha_ke
haled95335822ha_led
haler85033532ha_ler
hales85449842ha_les
half106238452ha_lf
hall75741162ha_ll
hallel93514092hallel
hallo85127552hallo
halls85633782halls
halm95834972ha_lm
halo76437322ha_lo
haloed104717602haloed
haloes94623862haloes
halon86124862halon
halos85230252halos
halt76056302ha_lt
halve114818922halve
hame97043132ha_me
hamlet113722792hamlet
hance105424152hance
handle104219292handle
hanse85722792hanse
hantle94318202hantle
hao67251122hao__
haply135915062haply
hare76255732ha_re
harl75740002harl_
harls85634502harls
haslet93222712haslet
hassle93711592hassle
haste85927862haste
hate78450172ha_te
haul75530452haul_
hauled104415212hauled
hauler95015122hauler
haulm104415412haulm
hauls86123732hauls
haute89521612haute
have106137072ha_ve
hawse116015122hawse
haze164833392ha_ze
hazel176414812hazel
hoe67562722h_o_e
hoke115935932h_oke
hold86235062h_old
holed95634132h_oled
holes84748652h_oles
holey115626902h_oley
holk116027942h_olk
holm95628112h_olm
holp95727552h_olp
hols76946292h_ols
holt77852582h_olt
holy106333432h_oly
home98042442h_ome
hone77549322h_one
hoolie93217782hoolie
hooly115022222hooly
hope96639672h_ope
hose76547242h_ose
hove107132222h_ove
howe106734102h_owe
hoyle11314412hoyle
jole117233822_jole
kale86533762ka_le
ladle66320442ladle
macle96127002macle
maile75232222maile
male66052302ma_le
maple95521142maple
mole66251832_mole
obole75917142obole
ole37155212__ole
padle84522342padle
pale66055012pa_le
parle75836162parle
parole84425252parole
pole65951302_pole
prole74527792prole
rale45050562ra_le
role45851822_role
sable74732162sable
sale44959702sa_le
shale85332832sha_le
sole46053672_sole
stole54928812stole
table75429602table
tale46154162ta_le
thole85620842thole
tole46052902_tole
vale74937342va_le
vole75236982_vole
wale74546442wa_le
whale115517432wha_le
whole114418092whole

Search took 5 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 Filter178691538000.626285448.9
2DLD Change Limit538001343.37315950.2
3Display Results1341340.0801675.0
 (SQL Overall)1786911344.07943807.6
 
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.