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

118 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
prelatic1231128(None) 
pelagic1237862p_elagic
pelitic111814652p_elitic
perlitic12310582perlitic
phreatic1548342phre_atic
prelate9519692prelat_e
prelates10418572prelates
prelatism1347852prelatism
protatic12314742protatic
pyelitic1547592pyelitic
anelastic1147043anelastic
aromatic12315633aromatic
bregmatic1644063bregmatic
creatin93618133cre_atin
cretic102816283cre__tic
deltaic1037023_deltaic
deltic9312503_del_tic
dramatic1369423dramatic
elastic93013393__elastic
enatic8317563__enatic
eremitic1248543eremitic
erratic9311113er_ratic
frenetic1346293frenetic
gelati73814533_gelati_
gelatin83514733_gelatin
gelatis83313513_gelatis
haematic151310213haematic
hematic141816743_hematic
hepatic141712773_hepatic
hieratic1349223hieratic
inelastic1146463inelastic
melanic11310403_melanic
nematic111713993_nematic
operatic1249933operatic
orectic1138823ore_ctic
palladic1346113palladic
paralytic1647973paralytic
paretic113016673pare__tic
pectic122913873p_e_ctic
pedantic1346583p_edantic
pelagics1345553p_elagics
peloric11310713p_eloric
pelvic13307553p_el_vic
peptic122113153p_e_ptic
periotic12313443periotic
phatic133014413p__hatic
phenetic1549203phenetic
phrenetic1645923phrenetic
phyletic1847213phyletic
piratic11314293p_iratic
plastic112815063p__lastic
pneumatic1545843pneumatic
poetic10416843poe__tic
politic112918713p_olitic
poplitic14510013poplitic
practic13312243pr_actic
pragmatic1647633pragmatic
prealter1048863prealter
preatomic1546023pre_atomic
prebiotic1545413prebiotic
precative16312573precative
predate10616893predat_e
predated12513273predated
predates11615813predates
predating13514653predating
predation12313463predation
predatism1447283predatism
predator11310053predator
prelacies13310053prelacies
prelacy1437583prela_cy
prelatisms1445703prelatisms
prelature1146263prelature
prelaunch1642153prelaunch
prelaw1139103prela__w
prelim10311423prel__im
prelimit1259123prelimit
premedic1546303premedic
prenatal1048373prenatal
prentice121012353pre_ntice
prepaid12310133prepa_id
preradio1145723preradio
prevail1238243preva_il
priapic1346023pr_iapic
prismatic1547163prismatic
proclitic1548113proclitic
prolactin1347773prolactin
prolamin12139753prolamin
prolate9419793prolat_e
proleptic1547113proleptic
prolific1546743prolific
prosaic11311163prosa_ic
prostatic13410853prostatic
pruritic1267403pruritic
psilotic1245773psilotic
psoatic1139303p_soatic
pyelitis1346583pyelitis
pyretic143210783pyre__tic
pyrolytic1957053pyrolytic
relaid75518443_rela_id
relate64033633_relat_e
related83327573_related
relater73723143_relater
relates73731433_relates
relating92725443_relating
relation82619773_relation
relative11313143_relative
relator74016363_relator
relaxin14239183_relaxin
relic74623363_rel__ic
rhematic15188923rhematic
sematic111716873_sematic
spermatic1548713spermatic
thematic152011483thematic
uralitic10158453uralitic
uratic83016353ur__atic
uretic82914353ure__tic
venatic12311523_venatic
villatic1346223villatic

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621186.86021306.4
3Display Results1181180.0631873.0
 (SQL Overall)1786911187.34324334.9
 
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.