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

111 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
pelagic123786(None) 
pelagics1345551pelagics
melanic11310402melanic
pelage9515362pelag_e
pelages10714612pelages
pelagial1146542pelagial
pelitic111814652pelitic
peloric11310712peloric
pelvic13307552pel_vic
prelatic12311282prelatic
ceramic1339823ceramic
delphic1545103delphic
deltaic1037023deltaic
deltic9312503del_tic
elain55324703_ela_in
elapid939543_elapid
elastic93013393_elastic
elegiac1045453_elegiac
elegit71212893_elegit
enatic8317563_enatic
epipelagic1751763epipelagic
felsic1147053fel_sic
gelati73814533gelati_
gelatin83514733gelatin
gelatis83313513gelatis
geologic1247793geologic
georgic1144293georgic
halakic1656663halakic
hematic141816743hematic
hepatic141712773hepatic
hexadic2045413hexadic
illogic1046013illogic
jalapic1844543jalapic
keramic1537233keramic
laic65931563__la_ic
logic88217833__logic
magic105818653__magic
melanics1237733melanics
melanin9310893melanin
melic94722333mel__ic
melodic1238543melodic
myalgic15134223myalgic
nematic111713993nematic
neologic1149233neologic
oologic1049423oologic
operatic1249933operatic
otalgic1045063otalgic
paladin101011773paladin
palais8420423pala_is
palladic1346113palladic
panic93923903p__anic
patagia1068783patagia
peag75431343pe_ag__
peage84723563pe_ag_e
peages94321843pe_ages
peags86122843pe_ag_s
pectic122913873pe_ctic
pedagog12113763pedagog
pedagogic1652963pedagogic
pedantic1346583pedantic
pedologic1546973pedologic
pellagra1143593pellagra
pellagrin1253253pellagrin
peloria9310953peloria
pelvics14245643pel_vics
pelvis113610323pel_vis
peptic122113153pe_ptic
peracid12312993peracid
perlitic12310583perlitic
phallic1447293phallic
phasic133612053p_hasic
phatic133014413p_hatic
pianic103714123p_ianic
piratic11314293piratic
placid114012543p_lacid
plagal948573p_lagal
plage84520403p_lag_e
plages94520153p_lages
plague93610853p_lague
plaguy12386413p_laguy
plaice10311553p_la_ice
plaid85118303p_la_id
plain74823303p_la_in
plait75631573p_la_it
plasmic13249113p_lasmic
plastic112815063p_lastic
pleonic1139433pleonic
podagric1443543podagric
polemic13311253polemic
politic112918713politic
potamic13310853potamic
priapic1346023priapic
psalmic1345333psalmic
psoatic1139303psoatic
puranic11410483puranic
pyelitic1547593pyelitic
pyloric1438063pyloric
reagin74915533re_agin
relaid75518443rela_id
relaxin14239183relaxin
relic74623363rel__ic
sebacic1346393sebacic
sebasic1146893sebasic
selenic9410663selenic
sematic111716873sematic
telic76019823tel__ic
telomic1147603telomic
tetanic9810133tetanic
tragic93811543_tragic
velaria1038923velaria
venatic12311523venatic

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.1561145455.1
2DLD Change Limit1340271117.04619021.7
3Display Results1111110.0333363.6
 (SQL Overall)1786911117.23524698.1
 
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.