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

147 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
sulphas123624(None) 
sulpha1135401sulpha_
alphas1139512_alphas
salpas85116922salp_as
subphase1555602subphase
sulfas9311562sul_fas
sulphate1346642sulphate
sulphates1466172sulphates
sulphid1346112sulphid
sulphids1444372sulphids
sulphur12123872sulphur
sulphurs1383652sulphurs
sylphs1435542sylph_s
alohas9411703_alohas
alpha1049653_alpha_
buddhas1463263buddhas
bugshas1334513bugshas
bumphs15467103bumph_s
buqshas2143573buqshas
culches143710743culches
culpa93610963culp_a_
culpae10389263culp_ae
cuppas12458593cu_ppas
dulias71212743dul_ias
ephas10311543__ephas
fulham1435303ful_ham
fulhams1543983ful_hams
gulches13398113gulches
gulpers10299013gulpers
gulps84715073gulp__s
hulas84920883hul__as
hulloas103911913hulloas
humphs16528163humph_s
huppahs1743333huppahs
kalpas124112943kalp_as
malthas1237913malthas
milpas101710273milp_as
mulches143210673mulches
muletas937383muletas
mullahs12388733mullahs
mullas84215933mul_las
murrhas12286173murrhas
nullahs10316993nullahs
ouphes113614633ou_phes
ouphs104311273ou_ph_s
pulpal10408453pulp_al
pulpers114612283pulpers
pulpits1137243pulpits
pulpous1177013pulpous
pulps95116483pulp__s
pupas95219283pu_p_as
ralphs1135373ralph_s
salinas73116093salinas
salivas10309603salivas
salpa75018353salp_a_
salpae84614273salp_ae
salpian938493salpian
salpians1036763salpians
salpids1038193salpids
salps74423243salp__s
salsas65316133sal_sas
salvias10279933salvias
scleras948223scleras
sculches15176273sculches
sculpins12216473sculpins
sculps104611753sculp__s
sculpts11377063sculp_ts
scyphus1743203scyphus
selahs9313213selah_s
selvas93812913sel_vas
sepias83616103s_epias
shophar1555463shophar
shophars1646353shophars
silicas9310603silicas
silvas92912183sil_vas
skyphos1963733skyphos
slushes103514413slushes
sophs104916023s_oph_s
spas67036723s__p_as
sradhas1176153sradhas
staphs114411033staph_s
stupas83910883stup_as
subahs114512383subah_s
subas74724073su__bas
subpar1048663subp_ar
subpenas1246903subpenas
subphases1645763subphases
succahs1435323succahs
sughs95313323su_gh_s
sukkahs1382703sukkahs
sulcal8311273sul_cal
sulcus8410493sul_cus
suldan72611043sul_dan
suldans8299723suldans
sulfa8313923sul_fa_
sulfids1137293sulfids
sulfurs1037343sulfurs
sulkers113613343sulkers
sulkies114315763sulkies
sulks94818463sul__ks
sullies74122233sullies
sulphated1544723sulphated
sulphide1444623sulphide
sulphides1544693sulphides
sulphite1346003sulphite
sulphites1445683sulphites
sulphone1345983sulphone
sulphones1446063sulphones
sulphury16122753sulphury
sultan63012593sul_tan
sultanas8237153sultanas
sultans72411833sultans
sulus54821883sul__us
summas104313163su_mmas
sumps95023433sump__s
sunnahs10326593sunnahs
sunnas63914563su_nnas
supers84622403su_pers
supes75628303su_p_es
suppers113314703suppers
supples11511283supples
supra73614253su_pra_
sups64834433su_p__s
surahs94515543surah_s
suras55336333su__ras
surpass938283surpass
surplus936793surplus
surras65919533su_rras
sushis9311183su_shis
sutras64818593su_tras
suttas63813793su_ttas
sylph1347793sylph__
sylphic1745883sylphic
sylphid1645963sylphid
sylphids1743953sylphids
sylphish1944273sylphish
sylphy1744153sylph_y
sylvas12288173syl_vas
syphs13519453s_yph_s
ulamas8910453_ulamas
ulemas888963_ulemas
ulnas55716533_ul_nas
ulpan7310123_ulp_an
ultras6310193_ultras
ulvas84511503_ul_vas
upas68322383_u_p_as
vulvas12388843vul_vas

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271475.84322938.0
3Display Results1471470.0502940.0
 (SQL Overall)1786911476.29928368.2
 
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.