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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
harassing134698(None) 
amassing1138002_amassing
brassing112612302_brassing
caressing1238802caressing
grassing103311972_grassing
harnessing1443902harnessing
abashing1466623_abashing
abasing10610673_aba_sing
arising83619973_ar_ising
arousing93811803_arousing
biassing11307263_biassing
braising113014563_braising
bypassing1742953bypassing
canvassing1643803canvassing
carousing1237893carousing
chorussing16193323chorussing
classing113211793_classing
crashing143512633_crashing
crossing112612683_crossing
cuirassing1343023cuirassing
damasking1744603damasking
degassing1234823degassing
dressing102810423_dressing
egressing1146853egressing
erasing8317963_era_sing
faradising1545273faradising
garaging1139043gara_ging
gassing94216333__gassing
glassing10329973_glassing
grasping12348833_grasping
grossing103111063_grossing
haranguing1543113haranguing
harass9313943harass___
harassed1237113harass_ed
harasser1137033harass_er
harassers1246193harassers
harasses11311033harass_es
harassment1554553harassment
harboring1538263harboring
hardening1438023hardening
haring104233003har___ing
harkening1746923harkening
harking154120943har__king
harming133717933har__ming
harping134118383har__ping
harrowing1646433harrowing
harrying15157643har_rying
harvesting1744413harvesting
hashing145020163h__ashing
hasping134414903h__asping
hassling1236803ha_ssling
hasting114725193h__asting
hazarding2343403hazarding
hearsing1239383h_earsing
heralding1435773heralding
hirsling1277543hir_sling
hissing114213143h__issing
hocussing1544093hocussing
horsing113215583hor__sing
marauding1344983marauding
massing104318023__massing
parading12313863para_ding
paralysing16235553paralysing
parasang1147333para_sang
parawing14310583para_wing
parsing103819553par__sing
passing104318423__passing
phrasing1438013phra_sing
praising113214563_praising
pressing112516443_pressing
prissing113011453_prissing
raising83220533__raising
rasing74330833__ra_sing
rasping104316253__rasping
rassling939013__rassling
repassing12249423repassing
reraising10313773reraising
sassing84615553__sassing
stressing1038333stressing
surpassing1343833surpassing
teargassing1352003teargassing
thrashing1635683thrashing
trashing122613223_trashing
trussing9268653_trussing
upraising1237263upraising
warsling12198593war_sling
wrassling1334273_wrassling

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 Filter1786911486410.423422437.4
2DLD Change Limit148641876.47022973.9
3Display Results87870.0461891.3
 (SQL Overall)178691876.93925751.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.