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

60 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
premedic154630(None) 
premedics1645301premedics
paramedic1645722paramedic
preedit10512462pre_edit
premed114617762premed__
premedical1745312premedical
premeds12389592premed_s
bromidic1544393bromidic
comedic14158633_comedic
emetic10614453__emetic
eremitic1248543eremitic
frenetic1346293frenetic
hermetic15310243hermetic
medic104619653___medic
paramedics1744153paramedics
periodic1348433periodic
permed115217353permed__
phenetic1549203phenetic
phrenetic1645923phrenetic
poromeric1547903poromeric
preaudit1177023preaudit
precede1239653preced_e
preceded1438293preceded
precedes13310713precedes
preceding15129363preceding
prededuct1543103prededuct
predict12315323pr__edict
preed85128123pre_ed__
preedits1168763pre_edits
preemie11310563pre_emie
prejudice2143343prejudice
prelatic12311283prelatic
premade12311443premad_e
premeal11310523preme_al
premeet11615153preme_et
premeiotic1653133premeiotic
premen105017803preme__n
premie103617993prem__ie
premix173710333prem__ix
premodify2043443premodify
preradio1145723preradio
presidia1147273presidia
presidio1146153presidio
preterit10315843preterit
preyed125313203preyed__
primed115118913primed__
prometric15410643prometric
prosodic1347693prosodic
proxemic2146153proxemic
pyemic1537893pyem__ic
pyramidic1943773pyramidic
reedit7617223_re_edit
remedial1147543_remedial
remedied1237953_remedied
remedies11310553_remedies
remedy1237873_remed_y
sememic1336503_sememic
trimeric1246933trimeric
uremic103410513urem__ic
ureteric1046233ureteric

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit146162607.75018859.6
3Display Results60600.0163750.0
 (SQL Overall)178691608.17221866.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.