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

265 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
pileous951052(None) 
piceous11310691piceous
pileus84514941pile_us
pilous84717751pil_ous
piteous9310681piteous
bilious9310932bilious
epigeous1146532epigeous
hideous1168432hideous
ileus54616892_ile_us
niveous1037192niveous
pigeons1039182pigeons
pilaus84114132pil_aus
piles74742612pile__s
pileum10399512pile_um
pileup10437922pile_up
pileups11365432pileups
pillows122610122pillows
pilots84018872pil_ots
pilus75921062pil__us
pious74621272pi__ous
pistous92714382pistous
pleons84213342p_leons
plexus15377282p_lexus
pulpous1177012pulpous
silenus7369692silenus
timeous938402timeous
villous102810022villous
aeneous739893aeneous
ailerons849843ailerons
apiaceous1344053apiaceous
aqueous1636053aqueous
bijous1548043bi_jous
bilboas11438733bilboas
bilboes114410243bilboes
bilbos105011203bilbo_s
biles75542143bile__s
billons93013363billons
billows123611293billows
boletus948643boletus
bulbous1138293bulbous
bullous9311663bullous
callous93516603callous
caseous9312513caseous
cineols9128853cineols
cirrous93111063cirrous
citreous1056853citreous
citrous93112993citrous
coleus86818273cole_us
dildoes9229243dildoes
dildos8179303dildo_s
dimerous1139323dimerous
duteous838453duteous
epigenous1245353epigenous
epilogs1076583epil_ogs
fibrous1237593fibrous
filers94623723file_rs
files85441273file__s
filets94718953file_ts
fillos94415083fillo_s
filos86125383fil_o_s
folious103710733folious
fulvous1334543fulvous
gallous82813953gallous
gaseous839503gaseous
gibbous1265333gibbous
griseous945613griseous
hideout1179793hideout
hideouts1285573hideouts
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
hilus84817643hil__us
hugeous1137133hugeous
igneous835773igneous
ileum74512823_ile_um
ilexes134510253_ilexes
iodous7311503_iodous
kilos95021473kil_o_s
libelous1047193libelous
lieus56218483li_e_us
ligneous945233ligneous
lilos55821873lil_o_s
luteous739273luteous
meous76120063__meous
miaous8511693mi_aous
milers84625163mile_rs
miles74645073mile__s
milieus939803milieus
milos75428013mil_o_s
mimeos104511543mimeo_s
nilgaus844003nilgaus
nimious937663nimious
niobous936333niobous
nitrous73512483nitrous
oilers64721193oile_rs
oleos55419683_oleo_s
osseous736053osseous
paeons83915523p_aeons
pales75753803pale__s
paletots1047803paletots
palets85122313pale_ts
pallors9314363pallors
palpus104210283pal_pus
pappous1057463pappous
pareos87023773pareo_s
pareus85420743pare_us
parlous9414293parlous
parous84024163p_arous
paseos88015813paseo_s
peles75738083pele__s
pelorus939273pelorus
peons75327183p__eons
pereons92815003pereons
perilous10310693peril_ous
petrous92714423petrous
phlegms1542373phlegms
phloems1433523phloems
phoebus1443823phoebus
pianos84315933piano_s
picots104616443pi_cots
pieces104217273pi_eces
piers75926333pi_e_rs
pies66949603pi_e__s
pietas84516503pi_etas
pigeon949413pigeo_n
piglets103311793pigle_ts
pignus937953pi_gnus
pigout9314613pi_gout
pigouts1037593pi_gouts
pikers124717393pike_rs
pikes115031033pike__s
pilaffs15365153pilaffs
pilafs113511023pil_afs
pilau73618523pil_au_
pilaws11399433pil_aws
pile65649693pile___
pilea75123953pile__a
pileate93815923pileate
piled85232993pile__d
pilei74021783pile__i
pileless1088623pileless
pilewort1389123pilewort
pileworts1495353pileworts
pilfers1238963pilfers
pilings103313613pilings
pilis75825203pil__is
pillars9313493pillars
pillions101610923pillions
pillory12247453pillory
pillow113110573pillo_w
pillowy15316423pillowy
pills74130973pil__ls
pilose84514243pil_ose
pilot77435063pil_o_t
pilules9510623pilules
pinaceous1345323pinaceous
pineals93212843pineals
pinenes93416673pinenes
pines76048863pine__s
pinetum1145553pinetum
pingoes105116523pingoes
pingos95317673pingo_s
pinions93413603pinions
pinkoes135512313pinkoes
pinkos125313873pinko_s
pinons86019943pi_nons
pinots85920273pi_nots
pintoes95117713pintoes
pintos86021293pinto_s
pinyons12299003pinyons
piolets93513193piole_ts
pions75826393pi__ons
pipeful1445643pipeful
pipefuls1543753pipefuls
pipers104318663pipe_rs
pipes96030143pipe__s
pipets105714773pipe_ts
piscos105112593pisco_s
pisos76021063pi_so_s
pistols93213983pistols
pistons93016373pistons
pistou83211843pistou_
piteously1446313piteously
pitons85319043pi_tons
pivots115111903pi_vots
pixels15478533pixe_ls
pixes144323173pixe__s
pleads94613953p_leads
pleas75627033p_le_as
pleats85218593p_leats
plebes104313623p_lebes
plebs95814583p_le_bs
plenum1039503p_lenum
plenums1136533p_lenums
pleon74216383p_leo_n
plews105415353p_le_ws
plexes155313533p_lexes
plexors1645423p_lexors
pliers84715153plie_rs
plies74526513plie__s
plods85719293p_l_ods
plops95920333p_l_ops
plots75025673p_l_ots
plows105419903p_l_ows
ploys105816593p_l_oys
plus66324833p_l__us
poaceous1267173poaceous
poilus82210573poil__us
poleis86018353pole_is
polers84225643pole_rs
poles75351003pole__s
poleyns1236113poleyns
polios84019723polio_s
polos76129913pol_o_s
polyols1238493polyols
polypous1547983polypous
polypus14346933polypus
pompous1338063pompous
porous84419483p_orous
poyous112911623p_oyous
preops104911943p_reops
pulers83820283pule_rs
pules74538813pule__s
pullout9310593pullout
pullouts1045223pullouts
pumiceous1563473pumiceous
pylons113011243pyl_ons
pylorus1235333pylorus
riles55343643rile__s
rimous8311913ri_mous
riotous739863riotous
sclerous1047913sclerous
selenous848973selenous
silents73514493silents
silexes1438653silexes
siliceous1145033siliceous
silos56029433sil_o_s
simious939803simious
sinuous739063sinuous
soleus64615613sole_us
spiles84227913spile__s
spinous9310443spi_nous
talcous939483talcous
teledus835093teledus
tilers63523503tile_rs
tiles55542103tile__s
timeout948593timeout
timeouts1044773timeouts
uveous936603_uveous
vicious1239493vicious
videos104911373video_s
villus93611223vil_lus
vinous93914173vi_nous
viperous1347613viperous
vireos94212453vireo_s
viscous1238833viscous
vitreous1145843vitreous
wideout1179033wideout
wideouts1275233wideouts
wigeons1136983wigeons
wiles85437873wile__s
willows13299753willows
wipeout1287873wipeout
wipeouts1354203wipeouts
zincous1837053zincous

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.1401276364.3
2DLD Change Limit1340272657.20318607.1
3Display Results2652650.0932849.5
 (SQL Overall)1786912657.43624030.5
 
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.