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

139 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
harissa103550(None) 
harissas1145981harissas
arista6415292_arista
barista9310812barista
charisma1576362charisma
crissa837622_crissa
harass9313942harass_
hariana10310242hariana
ahimsa1134783_ahimsa
amiss75823073_amiss_
aria46245423_ari__a
arias55438023_arias_
arils58732203_arils_
ariose64818723_ariose
ariosi64313033_ariosi
arioso64312403_arioso
arise56436433_ari_se
arisen65316793_arisen
arises65233803_arises
aristae7312533_aristae
aristas7413523_aristas
aristo6414033_aristo
arsis55722423_arsis_
barilla9310323barilla
baristas1039723baristas
briss75824273_briss_
camisa103114323cami_sa
camisas113411923camisas
camisia112810243camisia
caress85720263caress_
caries85147623caries_
carina84325323cari_na
carinas93622403carinas
carioca1139683carioca
caritas93316953caritas
chamisa14328853chami_sa
chamisas15317813chamisas
chariest13315503chariest
charism14712203chari_sm
charismas1655313charismas
charisms15710263charisms
chrisma1456823chrisma
crissal937413_crissal
crista8311803_crista
curiosa9346643curiosa
darics94314113darics_
farina94618233fari_na
farinas103215233farinas
farinha13357063farinha
garish104516923gari_sh
habits113014653habits_
haika125313793ha_i_ka
haiks125120933ha_iks_
hails85231643ha_ils_
hairiest11612463hairiest
hairs86225173ha_irs_
hajis156716283haji_s_
hakims1537303hakims_
halids104016133halids_
haniwa1236743hani_wa
hansa85416783ha__nsa
hansas94616043ha_nsas
harassed1237113harassed
harasser1137043harasser
harasses11311033harasses
hardass1139753hardass
hardest113118413hardest
hardies114923233hardies_
hardiest123416333hardiest
hards96435653har_ds_
hardset113415833hardset
harems115513823harems_
hares86255543har_es_
harianas1139163harianas
haricot12311963haricot
harijan1735783harijan
haring104233003hari_ng
harks126333433har_ks_
harls85634503har_ls_
harmins123716723harmins_
harms106829013har_ms_
harness102413933harness
harpies123818313harpies_
harpins123615703harpins_
harpist12312353harpist
harpists1338103harpists
harps105926873har_ps_
harries103525493harries_
harsh116418053har__sh
harts88441593har_ts_
harvest132112753harvest
haziest193313003haziest
hiss75629213h__iss_
hissy116112123h__issy
hoariest11312883hoariest
jarina134014063jari_na
jarinas143712183jarinas
kaross101910013kaross_
laris54737463lari_s_
madrassa11274633madrassa
mantissa1044573mantissa
marasca1136823marasca
maria75032883mari__a
marimba1354983marimba
marina84623413mari_na
marinas93519383marinas
mariposa1243703mariposa
marish114319053mari_sh
massa75518923ma__ssa
narcissi1043303narcissi
naris55735293nari_s_
orisha936773_orisha
paisa76021073pa_i_sa
paisas84317493pa_isas
paries84742513paries_
paris75145943pari_s_
parises94827183parises
parish115022353pari_sh
pavisse12546813pavisse
pharisee1347603pharisee
priss74623893_priss_
prissy11347853_prissy
sarins63932623sarins_
saris54544953sari_s_
sharia93116733shari__a
sharias102516003sharias_
sharifs13279903sharifs_
tarsia65514273tar_sia
tarsias74013373tarsias
turista737443turista
varia85824203vari__a
varias95019903varias_
varies94330873varies_
variola1068893variola
vibrissa1362223vibrissa
wariest105122503wariest
warison1037083warison
zariba1736983zari_ba
zaribas1836043zaribas

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.390458182.1
2DLD Change Limit1340271396.89019452.4
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.32624391.3
 
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.