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

149 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
pillared1122809(None) 
pillaged12298091pillaged
cellared11398792cellared
collared113211142collared
paillard1146262paillar_d
pileated112711132pileated
pilfered1435852pilfered
pillage103412602pillage_
pillager11278552pillager
pillages113012612pillages
pillar8314022pillar__
pillars9313492pillar_s
pilled94222752pill__ed
pilloried1265312pilloried
pillowed14156382pillowed
pollard103511142pollar_d
pollarded1344702pollarded
tillered937442tillered
allayed11138063_allayed
allured8299173_allured
ashlared1253933ashlared
billed94224903bill__ed
billeted1137643billeted
billiard1145873billiar_d
billowed14137063billowed
blared95018243__blared
bleared104211253_bleared
bollard103210503bollar_d
cellarer10317923cellarer
cellaret103713573cellaret
ciliated11510953ciliated
cleared103612463_cleared
collaged12279973collaged
collard103712923collar_d
collaret103116703collaret
collated113615063collated
declared1248743declared
dilated93115823di_lated
dilled84122223dill__ed
dullard936603dullar_d
epilated11310753epi_lated
fellated1239563fellated
filaree10611213fi_laree
filiated12610083filiated
fillagree1343623fillagree
fillagreed1541753fillagreed
filled104922263fill__ed
filleted1236603filleted
filliped1435223filliped
filtered12259043filtered
flared105317603__flared
fullered1236383fullered
gilled84521633gill__ed
gillied95512313gill_ied
glared84715193__glared
hilled104022223hill__ed
hilloaed12136923hilloaed
hilloed113211293hill_oed
hollaed11359853holla_ed
hollered1237603hollered
illuded9305763_illuded
illumed10285863_illumed
inlaced10239873_inlaced
killed113918773kill__ed
mallard10310273mallar_d
millage103112753millage_
millages113212903millages
milled94326173mill__ed
milleped1335173milleped
milliard1147033milliar_d
milliare1039153milliare_
milliares1149403milliares
milliped1337383milliped
millirem1245693millirem
misleared1277453misleared
nilled73919453nill__ed
paillards1244983paillards
palaced124110773p_alaced
palled94625163pall__ed
palleted1139873palleted
palliated1238493palliated
palmated132511003palmated
palpated13249763palpated
paltered113012483paltered
pared86946763p___ared
parlayed1435823parlayed
pelleted1138203pelleted
peltered112510453peltered
philtered1545493philtered
philtred14114183philtred
pickaxed2443513pickaxed
picrated132110113picrated
pictured1346573pictured
pilar75221503pi_lar__
pilchard1644553pilchar_d
pileate93815923pileate_
piled85232993pi_l__ed
pilferer1344923pilferer
pillagers12276923pillagers
pillaring1237653pillaring
pillarless1242543pillarless
pillories1189573pillories
pillory12247453pillor_y
piloted10310323pi_loted
pilular938203pilular__
pinnated11338553pinnated
pirated102515613pi_rated
pixilated1944543pixilated
pixillated2042503pixillated
placed114318003p__laced
planed94420913p__laned
plated95225773p__lated
played124815033p__layed
pleaded113511263p_leaded
pleased103712073p_leased
pleated103816633p_leated
plicated13310643plicated
poleaxed1854823poleaxed
polkaed1435323polka_ed
pollards11299523pollards
polled94022003poll__ed
pollened1157783pollened
polluted1135433polluted
poulard10299733poular_d
poularde11276573poularde
prepared132210873prepared
prilled104713003prill__ed
pulled94322193pull__ed
pulsated1136853pulsated
rilled74525653rill__ed
silvered12237563silvered
spillage1146263spillage_
spillages1256083spillages
spilled103613623spill__ed
tallaged10257923tallaged
tillage83111343tillage_
tillages93011263tillages
tilled74722953till__ed
ullaged937033_ullaged
villae95615383villa_e_
village113610833village_
villager12267513villager
villages123010603villages
violated1237883violated
wildered1336633wildered
willed104722453will__ed
willied114611563will_ied
willowed15156763willowed
willyard1543963willyar_d

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.423422437.4
2DLD Change Limit1461621497.18620339.8
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.67223291.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.