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

101 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
pyloric143806(None) 
peloric11310711peloric
pylori1147161pylori_
caloric113413222caloric
chloric143410612chloric
peloria9310952peloria
pylorus1235332pylorus
pyric123815072py__ric
baldric12166403baldric
boric98024223__boric
calorics122810463calorics
calorie92716903calorie
chlorid133211843chlorid
chlorin123113003chlorin
choric133515903_choric
cleric10612133_cleric
clonic104914673_clonic
colonic115015713colonic
cyclonic1446973cyclonic
dysuric1344533dysuric
florid10311453_florid
florin9312653_florin
fluoric1245813fluoric
gloria71910553_gloria
hydric15227953hy_dric
hylozoic2543663hylozoic
hypoxic2466283hypoxic
illogic1046013illogic
logic88217833__logic
lorica8310443__lorica
loris55329153__loris
lotic76420673__lotic
lyric104512723__lyric
melodic1238543melodic
motoric11312233motoric
mycotic1647713mycotic
myologic1647713myologic
myopic15308463my_opic
myotic133112313my_otic
oologic1049423oologic
parodic122311723parodic
parotic112518043parotic
pelagic1237863pelagic
pelitic111814653pelitic
pelorian1048883pelorian
pelorias10410593pelorias
pelorus939273pelorus
pelvic13307553pel_vic
phobic153010073p_hobic
phonic133315213p_honic
photic133316443p_hotic
phyletic1847213phyletic
phylic16279553phyl__ic
phyllomic2143383phyllomic
phytonic1848203phytonic
picric12309923p_icric
pilgrim1244643pilgrim
pionic103515953p_ionic
pleonic1139433pleonic
polemic13311253polemic
politic112918713politic
polyuric1555623polyuric
poori74816233p_oori_
pooris83916843p_ooris
psilotic1245773psilotic
ptotic102713373p_totic
pulmonic1445033pulmonic
pyaemic1645873pyaemic
pycnotic1745823pycnotic
pyelitic1547593pyelitic
pyemic1537893py_emic
pyic116915823py___ic
pyknic1734893py_knic
pyknotic1944203pyknotic
pylon103614003pylo__n
pylons113011243pylo_ns
pyoid11513763py_o_id
pyosis114012123py_osis
pyretic143210783pyretic
pyrexic21235353pyrexic
pyridic15267833pyridic
pyritic143311313pyritic
pyrosis12411653pyrosis
pyrrhic1744073pyrrhic
pyrrolic1544563pyrrolic
pythonic1847553pythonic
pyuria1136953py_uria
sylphic1745883sylphic
synodic1347363synodic
telomic1147603telomic
thoric114314043_thoric
toric76529313__toric
tylosin1046903tylosin
tyronic1239313tyronic
valeric1238303valeric
xyloid1738193xylo_id
yogic116114933_y_ogic
yonic105920843_y_onic
yttric1145433_yttric
zygotic2254663zygotic
zymotic2345713zymotic

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.423422437.4
2DLD Change Limit1340271017.12318816.1
3Display Results1011010.0333060.6
 (SQL Overall)1786911017.57923577.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.