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

172 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
pilular93820(None) 
pillar8314021pil_lar
alular6311352_alular
fibular12267972fibular
ligular8348532ligular
pabular11259472pabular
papular11299762papular
piacular1246572piacular
pilar75221502pi__lar
pillars9313492pil_lars
pilule8411122pilul_e
pilules9510622pilules
pinnular1044432pinnular
popular11319562popular
simular938672simular
spicular12238902spicular
titular737522titular
acicular12218663acicular
alula5317093_alula_
alulae6312743_alulae
angular838533angular
annular737693annular
avicular13237273avicular
axillar14247563axil_lar
bifilar1244043bifilar
biller84923483bil_ler
bilobular1392413bilobular
bilocular1363683bilocular
biovular1343603biovular
bipolar1145453bipolar
canular9310323canular
capitular1343773capitular
cellar84514983cel_lar
cellular1045163cellular
cingular11256973cingular
circular1247903circular
cislunar1082023cislunar
collar83816173col_lar
copular113810603copular
cupular11317623cupular
diluter8319663diluter
dilutor8256013dilutor
dipolar1056853dipolar
dollar74110983dol_lar
fabular12288693fabular
facular122810443facular
fibula11258053fibula_
fibulae12237013fibulae
fibulas12228563fibulas
filar84819293fi__lar
filler94623623fil_ler
fistular1144253fistular
giller74519733gil_ler
gular6314833__gular
hamular1236973hamular
hilar85418143hi__lar
hiller94421633hil_ler
iller54821293_il_ler
insular7138703insular
jocular1637303jocular
jugular1534513jugular
killer104917953kil_ler
kilobar1344613kilobar
ligula7359673ligula_
ligulae8308753ligulae
ligulas8329173ligulas
lingular9407503lingular
lobular936663lobular
locular938953locular
lunar57017313__lunar
lunular736013lunular
macular113011943macular
miller84625413mil_ler
modular1087363modular
morular978223morular
mutular936643mutular
nebular956483nebular
nodular876703nodular
ocular8610133_ocular
oscular937933oscular
ovular946833_ovular
paillard1146263pail_lard
palikar1335453palikar
pallor8313673pal_lor
palmar104113463pal_mar
paludal1035683paludal
papillar1296713papil_lar
papula103011113papula_
papulae11249353papulae
peculiar1245453peculiar
pedicular1445773pedicular
pedlar93311273p_edlar
pendular1144943pendular
phylar14437373p_hylar
picul95015363picul__
piculs103511753picul_s
piddler112911523piddler
pilaf103923483pi__laf
pilau73618523pi__lau
pilaw103913743pi__law
pilchard1644553pilchard
pilea75123953pil_ea_
pilfer1139163pil_fer
pill65339463pil_l__
pillage103412603pil_lage
pillager11278553pil_lager
pillared11228093pil_lared
pilled94222753pil_led
pillory12247453pil_lory
pillow113110573pil_low
pills74130973pil_l_s
pilsner935343pilsner
pilus75921063pilu__s
pinnula934913pinnula_
pinnulae1044183pinnulae
planar84212713p_lanar
planular1044753planular
plumular1243303plumular
plural839823p_lural
polar75623453p__olar
pollard103511143pol_lard
poller83921853pol_ler
poplar103611113p_oplar
poulard10299733p_oulard
primula1145713primula_
primulas1246123primulas
pula65129373p__ula_
puler74826623p__uler
puller83820813pul_ler
pulsar8329363pul_sar
pupilar11125313pupilar
pustular1045153pustular
radular837833radular
ranular739433ranular
regular838423regular
secular92211533secular
siller64026063sil_ler
similar937853similar
simulars1047073simulars
singular9327563singular
solunar735283solunar
spatular1044653spatular
specular12217613specular
spicula11259293spicula_
spiculae12218603spiculae
spiller92914333spil_ler
spinula9257903spinula_
spinulae10276963spinulae
spirula9257703spirula_
spirulae10216573spirulae
spirulas10207203spirulas
sporular1065223sporular
stipular1045843stipular
tabular9279763tabular
tegular836603tegular
tiller64222543til_ler
tissular843813tissular
titulars845863titulars
titulary1144873titulary
tubular9267473tubular
tumular9236543tumular
undular837123undular
ungular836773ungular
uvular955563_uvular
valvular1443463valvular
venular1037683venular
villa85321233vil_la_
villae95615383vil_lae
villas96117263vil_las
willer94021063wil_ler
zillah1836563zil_lah
zonular1656493zonular

Search took 7 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 Limit1340271726.25021444.3
3Display Results1721720.0632730.2
 (SQL Overall)1786911726.70626646.4
 
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.