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 “smelts” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
smelts8541277(None) 
melts74930101_melts
smalts85214891smalts
smells83914741smells
smelt74726781smelt_
smolts84411881smolts
spelts84614641spelts
aments85219802aments
belts75931162_belts
celts75325782_celts
delts65731792_delts
felts85324542_felts
gelts65924612_gelts
kelts95222632_kelts
malts76331752_malts
meats75034052_meats
meets74224612_meets
melds84822382_melds
mells75031332_mells
mels65941532_mel_s
melt65752892_melt_
melty104918362_melty
milts75430712_milts
molts76032092_molts
omelets938332omelets
pelts76128812_pelts
remelts93511492remelts
resmelts1046142resmelts
salts55431882s_alts
samlets93813552samlets
saults65816172saults
scents85317022scents
seats54844342s_eats
sects75622892s_ects
seels55632822seel_s
selfs85220242s_elfs
sells55134432s_ells
sels46345982s_el_s
septs75420602s_epts
sets45549502s_e_ts
setts55124322s_etts
sexts125118382s_exts
sheets93918492sheets
shells94319522shells
shelta93111782shelta
sheltas10279662sheltas
shelty124011542shelty
silts55330822s_ilts
skeets104513252skeets
skells105013782skells
skelms12368022skelms
skelps12407922skelps
sleets64318872sleets
smalls84514122smalls
smalt74729332smalt_
smalti84111172smalti
smalto84410282smalto
smaltos9408192smaltos
smarts86218002smarts
smears84714432smears
smeeks12428432smeeks
smell74916232smel_l
smelly114110352smelly
smelted10399092smelted
smelter93311912smelter
smelters103310512smelters
smerks12449712smerks
smews104612292sme_ws
smiles84522292smiles
smolt74824162smolt_
smuts75415712sm_uts
snells64614202snells
spells84617682spells
spelt75430192spelt_
speltz174010112speltz
steles63725662steles
stents65019452stents
stets55423912ste_ts
stilts67915302stilts
suets55126102sue_ts
svelte9319752svelte
sweats94814612sweats
sweets94214432sweets
swells93913982swells
welts85225192_welts

Search took 3 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 Filter178691825510.1061685764.2
2DLD Change Limit82551852.80029482.5
3Display Results85850.0136538.5
 (SQL Overall)178691852.91961216.5
 
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.