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

178 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
pileups1136543(None) 
pileup10437921pileup_
pileus84514941pileu_s
ileus54616892_ileu_s
lineups934912lineups
oilcups1143332oilcups
pickups1754252pickups
pilaus84114132pilau_s
pileous9510522pileous
piles74742612pile__s
pileum10399512pileu_m
pilous84717752pilou_s
pilus75921062pil_u_s
pinups1037412pi_nups
pullups1134232pullups
beleaps1138053beleaps
biceps12447713bice_ps
biles75542143bile__s
bleeps10499103_bleeps
buildups1342033buildups
coleus86818273coleu_s
diseurs839403diseurs
epilepsy1541723epile_psy
filers94623723file_rs
files85441273file__s
filets94718953file_ts
fillips12298133fillips
foldups1332733foldups
hiccups1643223hiccups
hilus84817643hil_u_s
holdups1333593holdups
ileum74512823_ileu_m
ileuses738673_ileuses
ilexes134510253_ilexes
juleps1535623jule_ps
keleps12478813kele_ps
kickups1443503kickups
leaps75522933__leaps
letups8317683__letups
leuds66214813__leuds
lieus56218483li_eu_s
lineup835983lineup_
linkups1333633linkups
loups75319623__loups
makeups1533603makeups
milers84625163mile_rs
miles74645073mile__s
milieus939803milieu_s
mixups1743263mi_xups
oilcup1044253oilcup_
oilers64721193oile_rs
oleums8358783_oleums
pailfuls1343843pailfuls
pales75753803pale__s
palets85122313pale_ts
palps94719563pal__ps
palpus104210283palpu_s
pareus85420743pareu_s
pasteups1243493pasteups
peeps95822363p__eeps
peles75738083pele__s
peps85134513p__e_ps
perps95521483p__erps
phlegms1542373phlegms
piceous11310693piceous
pickup1655633pickup_
piculs103511753pi_culs
pieces104217273pi_eces
piers75926333pi_e_rs
pies66949603pi_e__s
pietas84516503pi_etas
pigeons1039183pigeons
piglets103311793pigle_ts
pignus937953pignu_s
pignuts1035613pignuts
pigouts1037593pigouts
pikers124717393pike_rs
pikes115031033pike__s
pilaffs15365153pilaffs
pilafs113511023pil_afs
pilau73618523pilau__
pilaws11399433pil_aws
pile65649693pile___
pilea75123953pile__a
pileate93815923pileate
piled85232993pile__d
pilei74021783pile__i
pileless1088623pileless
pilfers1238963pilfers
pilings103313613pilings
pilis75825203pil__is
pillars9313493pillars
pillows122610123pillows
pills74130973pil__ls
pilots84018873pil_ots
pilule8411123pil_ule
pilules9510623pilules
pimps114616983pi__mps
pineals93212843pineals
pinenes93416673pinenes
pines76048863pine__s
pinesaps1253983pinesaps
pinup9612883pi_nup_
piolets93513193piole_ts
pious74621273pi_ou_s
pipefuls1543753pipefuls
pipers104318663pipe_rs
pipes96030143pipe__s
pipets105714773pipe_ts
pips85837133pi___ps
piques1739093pi_ques
piquets1836603piquets
piteous9310683piteous
pixels15478533pixe_ls
pixes144323173pixe__s
pleads94613953p_leads
pleas75627033p_le_as
pleats85218593p_leats
plebes104313623p_lebes
plebs95814583p_le_bs
plenums1136533p_lenums
pleons84213343p_leons
pleura837533p_leura
pleuras937413p_leuras
plews105415353p_le_ws
plexes155313543p_lexes
plexus15377283p_lexus
pliers84715153plie_rs
plies74526513plie__s
plops95920333p_l_ops
plugs85213493p_l_ugs
plumps124612613p_lumps
plums94619953p_l_ums
plus66324833p_l_u_s
poilus82210573poil_u_s
poleis86018353pole_is
polers84225643pole_rs
poles75351003pole__s
poleyns1236113poleyns
polyps13479763pol_yps
polypus14346933polypus
poseurs9378293poseurs
preops104911943p_reops
preps96220693p_re_ps
pseuds944793p_seuds
pulers83820283pule_rs
pules74538813pule__s
pullup1045893pullup_
pulps95116483pul__ps
pulques1835323pulques
pups86032233p___ups
pushups1433653pushups
riles55343643rile__s
saleps85014903sale_ps
scaleups1243393scaleups
shlepps14394833shlepps
shleps114710333shle_ps
sieurs659043si_eurs
silents73514493silents
silenus7369693silenus
silexes1438653silexes
sirups83710533si_rups
situps8538783si_tups
sleeps83913323_sleeps
slipups1133193slipups
soleus64615613soleu_s
spiles84227913spile__s
takeups1333403takeups
tilers63523503tile_rs
tiles55542103tile__s
tittups933353tittups
tuneups933333tuneups
upleaps1185233upleaps
villus93611223villu_s
walkups1633013walkups
wikiups16132083wikiups
wiles85437873wile__s
windups1334783windups

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.390458182.1
2DLD Change Limit1340271787.42318055.6
3Display Results1781780.0632825.4
 (SQL Overall)1786911787.87622688.0
 
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.