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

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

74 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
smectic1336611smectic
smectite1245772smectite
smelted10399092smelted
ameboid1277233ameboid
amentia9310153amentia
ejected17297653ejected
elected102812613elected
emeroid101511183emeroid
emetic10614453eme_tic
emetin8613463eme_tin
erected103213993erected
fetid93715983_fe_tid
foetid10510513foe_tid
hectic132311523_hectic
lectin82515013_lectin
mantid93820383_mantid
meated94222403_meated
meloid9616003_meloid
melted94219063_melted
meted85424433_me_ted
metis75025903_me_tis
mucid104115253_muc_id
mucoid1139783_mucoid
orectic1138823orectic
pectic122913873_pectic
pectin102615533_pectin
peptid112712373_peptid
recti73619623_recti_
sarcoid10310453sarcoid
scented102811883scented
sceptic1337833sceptic
seated75131063s_eated
second9411153s_econd
sect67443623s_ect__
sectile9311973s_ectile
section92515663s_ection
sector83415933s_ector
sects75622893s_ect_s
secund937103s_ecund
selected1159783selected
sematic111716883sematic
senti56226703s_enti_
septic102713193s_eptic
sheeted113813043sheeted
sheltie10109913sheltie
skeptic1545203skeptic
sleeted83113223sleeted
smacked163710993smacked
smalti84111193smalti_
smarted105012613smarted
smartie9310173smartie
smeared104510623smeared
smectites1344623smectites
smectitic1543433smectitic
smeeked14287223smeeked
smelled103511863smelled
smelt74726783smelt__
smelter93311913smelter
smelting11339713smelting
smelts85412773smelt_s
smerked14327283smerked
smocked16398223smocked
smutted1037463smutted
specced14266703specced
specie10412223spec_ie
specked16329013specked
specter113111733specter
spectra11275833spectra
spectre11297773spectre
steroid81314873steroid
stetted82610403stetted
sweated113411543sweated
sweetie10157873sweetie
synectic1546333synectic

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.393454684.5
2DLD Change Limit134027747.00019146.7
3Display Results74740.0302466.7
 (SQL Overall)178691747.42324072.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.