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 “hangared” 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
hangared133757(None) 
aneared8512742_aneared
angered93013472_angered
dangered11248512dangered
haggard13377182haggar_d
hangar104114512hangar__
hangars114313492hangar_s
hanged114222392hang__ed
hankered16289442hankered
hungered13217052hungered
saggared11326062saggared
sangaree949332sangaree
afeared1176833_afeared
angaria8311583_angaria
angaries9314393_angaries
angary10311323_angar_y
angeled93211513_angeled
angled84219093_ang_led
ansated84214003_ansated
antired82316193_antired
ascared10399523_ascared
augured987193_augured
badgered1336213badgered
bandaged1337313bandaged
banged104923723bang__ed
banjaxed2542353banjaxed
bannered11299323bannered
bantered113313633bantered
beggared1334753beggared
canaled103615563can_aled
canard9314763can_ar_d
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
canvased14246223canvased
changed144214143chang__ed
clangored1343663clangored
congaed11399743conga_ed
daggered12246403daggered
dandered112110963dandered
danged94819483dang__ed
dangled104013153dang_led
dungaree1045613dungaree
dungareed1242433dungareed
engaged10379833_engaged
fanfare1336673fanfare_
fanfares1436773fanfares
fanged114318223fang__ed
fingered13128333fingered
gandered112211173gandered
ganged94619193gang__ed
gangrel996143gang_rel
gingered11127743gingered
hachured1744393hachured
haggards14366763haggards
hagged124317703ha_g_ged
haggled13359283ha_ggled
haired105117173ha__ired
haltered123112563haltered
halyard1476973halyar_d
hammered16218853hammered
hampered16239933hampered
hanaper1237133han_aper
handaxes1938403handaxes
handed114919983han__ded
handled124114533han_dled
hangable1438213hangable
hangaring1438033hangaring
hangbird1543223hangbird
hanger104023253hang__er
hangers113120813hanger_s
hangfire1543763hangfire_
hangfires1643843hangfires
hangmen1337383hang_men
hangover15134433hangover
hanked144220603han__ked
hankerer15248233hankerer
hanseled1237713hanseled
hanted104124313han__ted
harbored1438633harbored
hared95742183h___ared
hatred104814333ha__tred
havered144011453ha_vered
hayward1736413haywar_d
hazard1938403ha_zar_d
hazarded2243643ha_zarded
hennaed1135103henna_ed
hindered1339453hindered
hinged114618923hing__ed
hongied12308163hong_ied
honored11310123hon_ored
honoured1236313honoured
hundred1237143hun_dred
hunkered16186923hunkered
jangled164111563jang_led
kangaroo1363473kangaroo
laagered1055853laagered
lagered92311153la_gered
laggard10347623laggar_d
lanated8313203lan_ated
langrel8107033lang_rel
laniard868523laniar_d
lanyard1167293lanyar_d
lingered10129643lingered
managed113212603man_aged
mandated12310293mandated
mangabey1643463mangabey
mangled113615263mang_led
mannered11249653mannered
mansard1049313mansar_d
mansarded1343993mansarded
manured1039473man_ured
manward1349093manwar_d
mongered1238953mongered
neared75119803__neared
pancaked1734893pancaked
pandered121812573pandered
panged104722333pang__ed
rancored1137233rancored
ranged84824313rang__ed
saggard10358953saggar_d
saggered11237553saggered
sandaled1039243sandaled
sangar73617683sangar__
sangarees1046543sangarees
sangars83116253sangar_s
shanghaied18141993shanghaied
snared74824553_sn_ared
sugared938583_sugared
tanged84622493tang__ed
tangled94214633tang_led
tangoed9318833tang_oed
tankard1267263tankar_d
tanyard1167183tanyar_d
ungarbed12197063_ungarbed
ungated92717213_ungated
vanguard1343893vanguar_d
vanward1456943vanwar_d
vinegared1442963vinegared
wagered12299333wa_gered
wandered132110793wandered
wangled123312413wang_led
whanged15447613whang__ed
zingare1737143zingare_

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621447.61019206.6
3Display Results1441440.0801800.0
 (SQL Overall)1786911448.09322079.7
 
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.