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

273 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
pileup1043792(None) 
pileum10399511pileum
pileups11365431pileups
pileus84514941pileus
ileum74512822_ileum
ileus54616892_ileus
lineup835982lineup
oilcup1044252oilcup
pickup1655632pickup
pilau73618522pilau_
pilaus84114132pilaus
pile65649692pile__
pilea75123952pile_a
piled85232992pile_d
pilei74021782pile_i
pileous9510522pileous
piles74742612pile_s
pilous84717752pilous
pilus75921062pil_us
pinup9612882pi_nup
pullup1045892pullup
ailed66240283aile_d
asleep847283asleep
beleap10410283beleap
bicep115413543bice_p
bile66147173bile__
biles75542143bile_s
bleep95013453_bleep
buildup1242333buildup
cilium104311373cilium
coleus86818273coleus
diseur738843diseur
faceup1334893faceup
file75446643file__
filed95331903file_d
filer85433003file_r
filers94623723filers
files85441273file_s
filet85540163file_t
filets94718953filets
fillip11268953fillip
filum105015433fil_um
foldup1233813foldup
hiccup1554393hiccup
hilum105514603hil_um
hilus84817643hil_us
holdup1245183holdup
ilea45931463_ile_a
ileac75814173_ileac
ileal56118083_ileal
ilex115822033_ile_x
ilium74614173_ilium
julep14310533jule_p
kelep116014553kele_p
kickup1354133kickup
leap66032683__leap
letup73712163__letup
leu36047403__leu_
leud57223423__leud
lieu46534363li_eu_
lieus56218483li_eus
lineups934913lineups
linkup1245123linkup
loup66028433__loup
makeup1434863makeup
mile66352563mile__
miler75733063mile_r
milers84625163milers
miles74645073mile_s
milieu8314103milieu_
milieus939803milieus
milieux1643783milieux
milium104712673milium
mixup1636773mi_xup
oilcups1143333oilcups
oiled64429473oile_d
oiler54628283oile_r
oilers64721193oilers
oleum73613323_oleum
pailful1236103pailful
pale66055013pale__
palea75028663pale_a
paleae84820293paleae
paleal84716673paleal
paled85538723pale_d
palely11311923palely
paler75436933pale_r
pales75753803pale_s
palest83926223palest
palet74650803pale_t
palets85122313palets
palp85828573pal__p
palpus104210283palpus
pareu74928743pareu_
pareus85420743pareus
pasteup1134983pasteup
peep85833693p__eep
pele65539553pele__
peles75738083pele_s
pep76447083p__e_p
perp89029893p__erp
phlegm1433093phlegm
pice84641093pice__
piceous11310693piceous
pickups1754253pickups
picul95015363pi_cul
pie55457403pi_e__
piece96717993pi_ece
pied75035363pi_e_d
pier66035293pi_e_r
piers75926333pi_ers
pies66949603pi_e_s
pieta75421753pi_eta
piety105817303pi_ety
pigeon949413pigeon
piglet93420923pigle_t
piglets103311793piglets
pignus937953pignus
pignut9311573pignut
pigout9314613pigout
pike106335213pike__
piked125623313pike_d
piker115622843pike_r
pikers124717393pikers
pikes115031033pike_s
pilaf103923483pil_af
pilaff143910363pilaff
pilafs113511023pilafs
pilar75221503pil_ar
pilaw103913743pil_aw
pilaws11399433pilaws
pileate93815923pileate
pilfer1139163pilfer
pilfers1238963pilfers
pili66130353pil__i
piling95025593piling
pilis75825203pil_is
pill65339463pil__l
pillar8314023pillar
pilled94222753pilled
pillow113110573pillow
pills74130973pil_ls
pilose84514233pilose
pilot77435063pil_ot
pilots84018873pilots
pilule8411123pilule
pily96132733pil__y
pimp106024903pi__mp
pine67755713pine__
pineal84817683pineal
pined85935323pine_d
pinene82915643pinene
pinery115214283pinery
pines76048863pine_s
pinesap1164723pinesap
pineta85815563pineta
pinetum1145553pinetum
piney105727503pine_y
pinups1037413pi_nups
piolet83225643piole_t
piolets93513193piolets
pious74621273pi_ous
pip78051043pi___p
pipe86434433pipe__
piped105123163pipe_d
pipeful1445643pipeful
piper96523193pipe_r
pipers104318663pipers
pipes96030143pipe_s
pipet95533323pipe_t
pipets105714773pipets
pique16410173pi_que
piqued1836213piqued
piques1739093piques
piquet17412353piquet
piteous9310683piteous
piu56639543pi__u_
pixel143911903pixe_l
pixels15478533pixels
pixes144323173pixe_s
plea66830603p_le_a
plead85818463p_lead
pleas75627033p_leas
pleat74734473p_leat
pleb86123813p_le_b
plebe95014873p_lebe
plebs95814583p_lebs
pled75231433p_le_d
plena75816393p_lena
plenum1039503p_lenum
pleon74216383p_leon
pleura837533p_leura
plew97222813p_le_w
plews105415353p_lews
plex137321373p_le_x
plexus15377283p_lexus
plie65127393plie__
plied85118593plie_d
plier75221283plie_r
pliers84715153pliers
plies74526513plie_s
plop86625743p_l_op
plug74915993p_l_ug
plum85122103p_l_um
plump115315263p_lump
plus66324833p_l_us
poilu72316003poil_u_
poilus82210573poil_us
pole65951303pole__
poleax1547993poleax
poled84934843pole_d
poleis86018353poleis
poler74431793pole_r
polers84225643polers
poles75351003pole_s
poleyn1157323poleyn
polyp125611533pol_yp
poseur8419403poseur
preop94715873p_reop
prep86427673p_re_p
pseud867043p_seud
pule65040953pule__
puled84926523pule_d
puler74826623pule_r
pulers83820283pulers
pules74538813pule_s
pullups1134233pullups
pulp84825353pul__p
pulque1736213pulque
pup76339883p___up
pushup1335273pushup
rile45650533rile__
riled65833253rile_d
riles55343643rile_s
riley84420583rile_y
salep77022953sale_p
scaleup1134483scaleup
shlep104914833shle_p
shlepp13366193shlepp
sieur5911893si_eur
sileni63312143sileni
silent64125843silent
silenus7369693silenus
silex123417413sile_x
sirup74014913si_rup
situp74414063si_tup
sleep74920183_sleep
slipup1034503slipup
soleus64615613soleus
spile75230083spile__
spiled94621993spile_d
spiles84227913spile_s
takeup1234583takeup
tile45451443tile__
tiled64832943tile_d
tiler56131023tile_r
tilers63523493tilers
tiles55542103tile_s
tittup834203tittup
tuneup835203tuneup
upleap10106843upleap
vile76139803vile__
vilely1239443vilely
viler86324163vile_r
vilest9416843vilest
villus93611223villus
walkup1534193walkup
wikiup15183533wikiup
wile75944373wile__
wiled95231553wile_d
wiles85437873wile_s
wilful1235963wilful
windup1235383windup

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162736.53317253.3
3Display Results2732730.0763592.1
 (SQL Overall)1786912736.74926476.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.