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

106 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
harasser113704(None) 
harassed1237111harassed
harassers1246201harassers
harasses11311031harasses
amasser9418732_amasser
caresser1038812caresser
crasser94114342_crasser
harass9313942harass__
hardasses1346452hardasses
harsher13310362har_sher
abaser86414343_aba_ser
amassed10388633_amassed
amassers10337843_amassers
amasses93912853_amasses
arouser74514423_arouser
artsier768943_artsier
badassed1244273badassed
badasses1136173badasses
bagasse1035143bagasse_
bagasses1136313bagasses
brasher124515243_brasher
brasier94516753_brasier
brassed103612373_brassed
brasses93818353_brasses
brassier103310533_brassier
cadaster1136903cadaster
camasses12388973camasses
canvasser14274263canvasser
carassow1343253carassow
carcasses1337483carcasses
caressed1139163caressed
caressers1137443caressers
caresses10314063caresses
carouser1068853carouser
character1645883character
charases131312763chara_ses
classer93614613_classer
crasher124616163_crasher
crosser95015463_crosser
degasser10325813degasser
dresser83611953_dresser
eraser64216333_era_ser
frasses104314513_frasses
gasser75017773__gasser
grasper10389793_grasper
grassed93812793_grassed
grasses84117343_grasses
grassier9349283_grassier
grosser84313143_grosser
hamster12810423ha_mster
hanaper1237133hana_per
haranguer1342863haranguer
harassing1346983harassing
harassment1554553harassment
harborer1348053harborer
hardass1139753hardass__
hardener1238883hardener
harder105022403har__der
hardier114721543har_dier
hardset113415833har_dset
harissa1035503hariss_a
harissas1145983harissas
harkener1537573harkener
harmer114719553har__mer
harnessed13186193harnessed
harnesses121812073harnesses
harper115018403har__per
harrier104417753har_rier
harrower1446363harrower
harshen1339283har_shen
harslet10315653har_slet
haruspex2041683haruspex
harvester1544333harvester
hassel95614213h__assel
hawser125910843h__awser
hazarder2143603hazarder
hisser94713793h__isser
hoarser10388393h_oarser
horsier103013243hor_sier
karosses1236493karosses
kavasses1544303kavasses
marauder1144553marauder
matrasses1157293matrasses
morasses1038903morasses
parader103914863para_der
parser84822373par__ser
passer84721033__passer
praiser93413943_praiser
presser93717623_presser
raiser66620103__raiser
raser55633413__ra_ser
rasher95024123__rasher
rasper83917333__rasper
raster64731443__raster
strasses81311443strasses
surpasser1143863surpasser
tarsier74119253tar_sier
thrasher1455743thrasher
trasher104416133_trasher
trasses74819323_trasses
trusser74010263_trusser
upraiser10175843upraiser
vavassor1441723vavassor
warsler10289893war_sler
wrasse9398773_wrasse_
wrasses103812593_wrasses

Search took 8 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.423422437.4
2DLD Change Limit1461621066.98320931.1
3Display Results1061060.0303533.3
 (SQL Overall)1786911067.43624030.5
 
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.