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

276 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
harpist1231235(None) 
harpists1338091harpists
artist64125542_artist
chartist131112132chartist
happiest152411672happiest
hardest113118412hardest
hardiest123416332hardiest
harpies123818312harpies
harpin113614382harpi_n
harping134118382harping
harpins123615702harpins
harps105926862harp_s_
harvest132112752harvest
hornist102314822hornist
narcist9512442narcist
papist102618742pa_pist
rapist82520672ra_pist
sharpest1339142sharpest
ageist7315383_ageist
agist66325583_a_gist
airpost939243airpost
alarmist1049123alarmist
alist56136783_a_list
aorist64827873_aorist
apish105116633_a_pish
arise56436433_ar_ise
arista6415293_ar_ista
aristo6414033_ar_isto
armpit10811093_armpi_t
armpits1157123_armpits
aroint6328153_aroint
arpent84822093_arpent
arrest63722633_arrest
arris56824683_arris_
arsis55722423_arsis_
artiest73121993_artiest
artiste73813693_artiste
artists74215583_artists
aspis74618143_aspis_
aspish114810333_aspish
assist6314603_assist
aurist65027253_aurist
autist64324943_autist
baptist11311873baptist
barest85327693bar_est
barista9310813bar_ista
barkiest144115153barkiest
barmiest125212783barmiest
barniest104815053barniest
bassist9312743bassist
cambist13312103cambist
campiest142212133campiest
capris10415073capris_
carlish12312763carlish
carpet104530093carp_et
carpets113915333carpets
carpi94319393carpi__
carping123521083carping
carport11316033carport
carps96932253carp_s_
carpus105514303carpus_
casuist9411303casuist
chariest13315503chariest
chariot12316213char_iot
charism14712203char_ism
charpais1536923charpais_
charriest1438253charriest
chartists14126803chartists
chirpiest16286473chirpiest
czarist18710223czar_ist
dadaist9310103dadaist
dampest12411043dampest
dampish1567663dampish
darkest122512623darkest
darkish1537943darkish
diarist8517113diar_ist
earliest82415243earliest
earnest7318733earnest
faddist12289643faddist
fascist1239213fascist
fauvist1336663fauvist
gappiest13259473gappiest
garfish14179203garfish
garish104516923gar_ish
garnish111610843garnish
garpike1435093garpike
gharris11306433gharris_
grapiest112211923grapiest
grist65529873_gr_ist
habit103027013ha_bi_t
habits113014643ha_bits
haddest122711993haddest
hadjis17439633hadjis_
hadst93220223ha__dst
haffit1538533haffi_t
haffits1636193haffits
hagadist1347603hagadist
hagfish17227613hagfish
haggis11209513haggis_
haggish15207473haggish
haimish1537753haimish
haint85436323ha__int
hairiest11612463hairiest
hairpin1245413hairpi_n
hairpins1365433hairpins
hajis156716273ha_jis_
hajjis15485883hajjis_
halakist15158223halakist
halest94823273ha_lest
hammiest152610003hammiest
handiest123417773handiest
handlist12311333handlist
happier143312033happier
happily1745763happily
happing153817233happing
haps96443463ha_p_s_
harass9313943har_ass
hardass1139753hardass
hardhat14411023hardhat
hardier114721543hardier
hardies114923233hardies
hardily143310273hardily
hards96435653har_ds_
hardset113415833hardset
harems115513823harems_
hares86255543har_es_
haricot12311963haricot
haring104233003har_ing
harissa1035503harissa
harking154120943harking
harks126333433har_ks_
harlot94422803har_lot
harlots103413293harlots
harls85634503har_ls_
harmin113117393harmi_n
harmine122816193harmine
harming133717933harming
harmins123716713harmins
harmonist141310663harmonist
harms106829013har_ms_
harness102413933harness
harp96134283harp___
harped124418403harp_ed
harper115018403harp_er
harpers124916203harpers
harpings14379773harpings
harpoon1238313harpoon
harpy136418203harp__y
harried113815533harried
harrier104417753harrier
harries103525493harries
harsh116418053har__sh
harshest14310193harshest
harslet10315653harslet
hart76865773har___t
harts88441593har_ts_
harvests14246173harvests
hashish1238353hashish
hasping134414903hasping
hasps105114643hasp_s_
hast76259483ha___st
hastiest112916493hastiest
hatpin112610603hatpi_n
hatpins123410643hatpins
hawkish2036553hawkish
haziest193313003haziest
heartiest12311103heartiest
heist87030913h__eist
hempiest1539023hempiest
heppest14228143heppest
herbiest1339993herbiest
heriot9422343her_iot
hermit11519443hermi_t
hermits12312133hermits
heroism12311013heroism
herpes115517323herpes_
hippest14219753hippest
hippiest152611613hippiest
hippish1736183hippish
hist76551543h___ist
hoariest11312883hoariest
hoarsest1137133hoarsest
hoist86433213h__oist
holist94723213h_olist
hoppiest152610723hoppiest
horniest112814043horniest
hornists11208833hornists
horsiest112513263horsiest
horst85833513hor__st
humpiest1538963humpiest
hurst85527193hur__st
hygeist1445793hygeist
hymnist1546633hymnist
jurist134616393jur_ist
karst97228993kar__st
lapis76223153la_pis_
lardiest93813883lardiest
largest83715103largest
largish1138603largish
lariat6629043lar_iat
laris54737463lar_is_
larkiest123713313larkiest
larkish1439083larkish
lyrist9312293lyr_ist
maist75535673ma__ist
marish114319053mar_ish
marliest102415183marliest
marplot1149673marplot
nappiest122510883nappiest
narcism1188733narcism
narcists1078113narcists
naris55735293nar_is_
oarfish13158613oarfish
oralist7619633oralist
palmist112814343palmist
papism122211513pa_pism
papists112110453pa_pists
pappiest112611113pappiest
paris75145943par_is_
parish115022353par_ish
parodist11412763parodist
parvis116114803parvis_
parvise124211693parvise
persist9315853persist
phallist1338983phallist
purist85525053pur_ist
racist82822793ra_cist
rapists92510743ra_pists
rarest65725483rar_est
raspiest10311273raspiest
raspish1298103raspish
sacrist9315423sacrist
sadist74221353sa_dist
sapphist1545763sapphist
sappiest122612573sappiest
saris54544953sar_is_
sarkiest123615063sarkiest
sarodist9510923sarodist
sharpie1238383sharpi_e
sharpies13411223sharpies
sharping143011373sharping
sharps115516083sharp_s_
tachist12613293tachist
tanist6324593ta_nist
tapis75028863ta_pis_
tardiest93515243tardiest
tarnish101611873tarnish
tarps76527113tarp_s_
tarriest83215003tarriest
tartest72517533tartest
tartiest82718313tartiest
tartish101512633tartish
therapist1447073therapist
tsarist7712253tsar_ist
typist1139823_typist
tzarist1659103tzar_ist
utopist938693utopist
vampiest15237643vampiest
vampish1766283vampish
varmint12311683varmint
varnish13169533varnish
verist93823893ver_ist
waist86132383wa__ist
wampish1777293wampish
wariest105122503wariest
warmest123113033warmest
warmish1538373warmish
warping133715183warping
warps107126423warp_s_
warpwise1642853warpwise
wartiest113614643wartiest
waspiest1338813waspiest
waspish1586923waspish
wrist84827563_wr_ist
yarest95018913yar_est
zappiest21228023zappiest

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272766.89319443.9
3Display Results2762760.0932967.7
 (SQL Overall)1786912767.14225019.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.