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

109 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
harsh11641805(None) 
hash106936501ha_sh
marsh105320851marsh
aargh96314082aargh
arch98628442_arch
ars37670932_ars_
arse46539272_arse
ash67944602_a_sh
bars66564092bars_
bash915240162ba_sh
brash106221562brash
cars67364762cars_
carse74934332carse
cash96636282ca_sh
chars105936632chars_
crash109120012crash
dash87031632da_sh
ears46356592ears_
earth85023052earth
fash107232292fa_sh
garish104516922garish
gars55750742gars_
garth94720222garth
gash86833022ga_sh
girsh95310022girsh
gursh94512332gursh
haars85620472haars_
hadst93220222hadst
haes77651022haes_
hags86740842hags_
hah910655222ha__h
hahs108333362hahs_
hairs86225172hairs_
hams96446132hams_
hansa85416782hansa
hanse85722792hanse
haps96443462haps_
harass9313942harass
hard85443502har_d
hards96435652hards
hardy125622062hardy
hare76255732har_e
hared95742182hared
harem104924452harem
hares86255542hares
hark115237392har_k
harks126333432harks
harl75740002har_l
harls85634502harls
harm95637792har_m
harms106829012harms
harp96134282har_p
harps105926862harps
harpy136418202harpy
harry115322952harry
harshen1339282harshen
harsher13310362harsher
harshly1636272harshly
hart76865772har_t
harts88441592harts
has67372652ha_s_
hasp96627292ha_sp
hast76259482ha_st
hatch135719592hatch
hath105933912ha_th
hats76858252hats_
haugh125114052haugh
haws106439442haws_
hawse116015122hawse
hays106138072hays_
hears86737372hears_
hearse94114272hearse
hearth125315212hearth
hers75844872hers_
hoars85925542hoars_
hoarse94411322hoarse
horah117922042horah
horse86132652horse
horst85833512horst
horsy116318392horsy
hurst85527192hurst
hush105224112h_ush
jars117338352jars_
karst97228992karst
larch105919792larch
lars46956572lars_
lash76539652la_sh
march125622892march
marish114319052marish
mars66261862mars_
marse76231152marse
marshy14558332marshy
mash96039392ma_sh
oars46846032oars_
parch125123002parch
parish115022352parish
pars67560792pars_
parse75236992parse
pash95638132pa_sh
qursh174110842qursh
rash76039932ra_sh
sash77235302sa_sh
tars46763952tars_
tarsi55222172tarsi
thrash12258352thrash
trash86119762trash
vars75742072vars_
wars78659802wars_
wash106033812wa_sh

Search took 4 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.0931921408.6
2DLD Change Limit538001093.53315227.9
3Display Results1091090.0601816.7
 (SQL Overall)1786911093.68648478.3
 
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.