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

416 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
unpiles9211278(None) 
unpile81914321unpile_
unpiled102312741unpiled
uppiles11208261uppiles
ensiles72714832ensiles
huipiles1344422huipiles
piles74742612__piles
spiles84227912_spiles
umpires1137812umpires
unbales92914862unbales
uncles8317162un_cles
undies73821962undi_es
undines8716082undines
unfixes17238112unfixes
unites65024852un_ites
unlives102010952unlives
unmixes16197752unmixes
unoiled82415472unoiled
unpicks1545182unpicks
unpins82312382unpi_ns
unties64326922unti_es
uppile10178502uppile_
uppiled12216592uppiled
aediles83413903aediles
alpines94016193alpines
ampules1189433ampules
aneles64626293an_eles
angles74426703an_gles
anile54634463an_ile_
anils56326723an_il_s
animes84719593an_imes
anises64826693an_ises
ankles104818383an_kles
anoles64827423an_oles
anviled1138943anviled
anvils9219713anvil_s
apices104916263_apices
apples104315763_apples
applies11311213applies
aspires9612043aspires
aspises9611643aspises
audiles83112613audiles
aunties73920073aunti_es
auspices1236443auspices
biles75542143__biles
bundles103515773bun_dles
bungles104116763bun_gles
bunnies94415003bunni_es
buppies133011063buppi_es
capizes20410373capizes
centiles103615813centiles
chiles115425303_chiles
compiles14311983compiles
copies104130303copi_es
cupules113210263cupules
cuspides13306943cuspides
dapples1238993dapples
deciles104417723deciles
defiles114016843defiles
dipoles101013753dipoles
dunites8313593dun_ites
dunnites947173dunnites
ediles74016983_ediles
empales112411433empales
empires1139853empires
enables92813123enables
endites83717063endites
endives113710693endives
engilds974863engilds
engines81114463engines
enisles72312603enisles
enophiles1448433enophiles
ensile62616473ensile_
ensiled82611433ensiled
entices91616333entices
entires71517783entires
entitles8710663entitles
envies9314053envi_es
espies83716803espi_es
etoiles7411293etoiles
exiles134816403_exiles
expires1638683expires
files85441273__files
fipples14298653fipples
fungibles1542813fungibles
funicles13246833funicles
funnies104113603funni_es
funplex1932833funp_lex
gentiles93713523gentiles
guiles73919283_guiles
gunfires1235063gunfires
gunites8313123gun_ites
gunnies83413123gunni_es
gunwales1244733gunwales
guppies123310523guppi_es
hopples142810713hopples
huipils1243533huipil_s
hunkies143214503hunki_es
impales113311763impales
implies11312123implies
incises93414893incises
incites93218483incites
indices103513443indices
indies73822783indi_es
indites83618983indites
indoles83716363indoles
infixes17238133infixes
ingles74420873in_gles
inhales10511863inhales
inkles103515653in_kles
insides8512653insides
insoles73516243insoles
inspires1037623inspires
intines7921113intines
intitles8710003intitles
invites103915813invites
jubiles16289373jubiles
jungles154112543jun_gles
junkies183711693junki_es
knifes136210213kn_ifes
knives13458553kn_ives
kunzites2143243kunzites
lapides103012043lapides
lapises93513463lapises
lipides103810623lipides
lunies64723013lun_i_es
lunules738953lun_ules
lupines93912503lupines
mailes84329113_mailes
maniples12269423maniples
maples104819423map_les
miles74645073__miles
mobiles112813123mobiles
motiles93317433motiles
muspikes1635243muspikes
nailed74021493_nailed
nailer64119363_nailer
nailers73215893_nailers
nails55730403_nail_s
naives94914223_naives
nides65229133_n_ides
nills54926673_n_ills
nils46132453_n_il_s
nines55937343_n_ines
nipples11319663nipples
nites55736343_n_ites
nixes124519623_n_ixes
nobles83319723_nobles
noils55024333_noil_s
noises65021853_noises
nopales93812523nopales
nubbles113412433nubbles
nubile83212713nubile_
nudies75217093nudi_es
numbles113814273numbles
nuncles939843nuncles
nuzzles15298123nuzzles
opines84820703_opines
orpines94414793orpines
outwiles1139233outwiles
pales75753803__pales
panpipes1135173panpipes
pantiles103617153pantiles
papules112411573papules
peles75738083__peles
pies66949603__pi_es
pikes115031033__pikes
pile65649693__pile_
pilea75123953__pilea
piled85232993__piled
pilei74021783__pilei
pileus84514943__pileus
pilis75825203__pilis
pills74130973__pills
pilus75921063__pilus
pines76048863__pines
pipes96030143__pipes
pixes144323173__pixes
plies74526513__plies
poles75351003__poles
popples103011873popples
pules74538813__pules
pungles104013713pun_gles
punkies134216803punki_es
punties94520783punti_es
pupils10389913pupil_s
puppies103212613puppi_es
purples112712823purp_les
quantiles1846603quantiles
quintiles1845983quintiles
ranpikes1435643ranpikes
rapines95120863rapines
refiles104122423refiles
repines94927383repines
replies94521043replies
reptiles103913063reptiles
resiles74026543resiles
retiles74426993retiles
reviles104421353reviles
riles55343643__riles
ripples113513293ripples
rumples113313133rump_les
rundles83214713run_dles
runkles114111943run_kles
rutiles74315843rutiles
sandpiles1246303sandpiles
seniles72618023seniles
shunpikes1841903shunpikes
similes92915233similes
smiles84522293_smiles
snailed83811923snailed
snails64816653snail_s
snipes83917393sn_ipes
sopites93817173sopites
spales84728103_spales
spices104326033_spices
spiels85317953_spiels
spies76037623_spi_es
spikes124520713_spikes
spile75230083_spile_
spiled94621993_spiled
spills84717463_spills
spines85132033_spines
spires84628113_spires
spites84127333_spites
stiles64328773_stiles
subfiles131710723subfiles
sunrises8310693sunrises
supines94216383supines
supples11511283supples
supplies1268833supplies
suspires1038203suspires
swiples12339643swiples
tapises92914013tapises
tiles55542103__tiles
tipples112811253tipples
toiles63923513_toiles
topples113111653topples
triples94616873triples
tunicles10217133tunicles
tunnies73614263tunni_es
turnpikes1542273turnpikes
uglies7412323ugli_es
umbles103817493u_mbles
umpire1047893umpire_
umpired1235783umpired
unable83819223unable_
unagile838283unagile_
unaided92414603unaided
unaimed102812493unaimed
unaired82916013unaired
unais53420773unai__s
unakites1237543unakites
unbale83616403unbale_
unbaled103315963unbaled
unbelts9237663unbelts
unbilled1188693unbilled
unbinds10267353unbinds
unblest9411813un_blest
unboiled112410373unboiled
unbolts9247803unbolts
unboxes16208303unboxes
unbridles1244133unbridles
unbuilds1143153unbuilds
uncages103213773uncages
uncakes133012743uncakes
uncases93516553uncases
unciae83215313unciae_
uncials92510523uncials
uncinus937403uncinus
uncle7317053un_cle_
unclips1136433unclips
uncoiled112512683uncoiled
uncoils979533uncoil_s
undine7817263undine_
undoes73917403un_does
uneases73316263uneases
unfilled1298383unfilled
unfilmed1495803unfilmed
unfired112212453unfired
unfits93910293unfi_ts
unfixed18218563unfixed
unfoiled12249723unfoiled
unfolds11146803unfolds
unfrees1048643unfrees
ungirds9105303ungirds
unglues836993unglues
ungues7412123un_gues
unhailed12219963unhailed
unhelms1234223unhelms
unhinges12266723unhinges
unhired112512153unhired
unifies102714713unifies
unions64216753un_ions
unipods1095703unipods
uniques1667443uniques
unisex1358353un_isex
unite54828383un_ite_
united74421543un_ited
uniter64619143un_iter
uniters73814173un_iters
unities72520153unities
unitizes1739133unitizes
units54923433un_i_ts
unkinks10265413unkinks
unlaces92513623unlaces
unlades82612833unlades
unled64021073un__led
unless62413073un__less
unlet54133333un__let
unlike102614063unlike_
unliked122411283unliked
unlined82515803unlined
unlinks11307403unlinks
unlive92712333unlive_
unlived112511373unlived
unmailed11229763unmailed
unmakes132810793unmakes
unmilled1197853unmilled
unmined102612953unmined
unmingles1243983unmingles
unmiter9310393unmiter
unmiters1037073unmiters
unmitres1036863unmitres
unmixed17228213unmixed
unmolds10135743unmolds
unnailed9229443unnailed
unnails738223unnail_s
unpacks1576093unpacks
unpaged113311043unpaged
unpaired11208943unpaired
unpaved133410053unpaved
unpeeled11118533unpeeled
unpeg8309363unp__eg
unpegs9256233unp_egs
unpen72913573unp__en
unpens82511013unp_ens
unpeoples1343503unpeoples
unpick1446903unpi_ck
unpicked17237213unpicked
unpiling1139753unpiling
unpin72613243unpi__n
unpinned1136383unpinned
unpitied1138793unpitied
unpitted1148623unpitted
unplug954413unp_lug
unplugs1042983unplugs
unpoised1139183unpoised
unpolled1168943unpolled
unposed10711903unposed
unpriced1338143unpriced
unprimed1337203unprimed
unprized2038513unprized
unpure82911533unpure_
unpuzzles1941823unpuzzles
unreels7258313unreels
unriddles1143503unriddles
unrifled1237423unrifled
unrigs7159003unri_gs
unrimed102211633unrimed
unripe82012093unripe_
unriper9188283unriper
unripest1046083unripest
unrips8199453unri_ps
unrisen7229283unrisen
unrobes9269733unrobes
unrolls797793unrolls
unruled8311373unruled
unsells73210773unsells
unsexes14248923unsexes
unsilent849603unsilent
unsized172510543unsized
unsoiled92412083unsoiled
unspilled1245093unspilled
unspilt938853unspil_t
unspoiled12255563unspoiled
untidies939813untidies
untie54425493unti_e_
untied73720813unti_ed
until53517743until__
untilled9710563untilled
untilted9610893untilted
untimed102713373untimed
untired82316383untired
untitled978763untitled
untunes72211253untunes
untwines1137603untwines
unveiled1298163unveiled
unveils1045753unveil_s
unvoices13125163unvoices
unwilled1277823unwilled
unwinds11286733unwinds
unwise9510803unwise_
unwiser1037123unwiser
unwisest1165123unwisest
unwishes14147483unwishes
unwits9389893unwi_ts
unyokes1466733unyokes
unzips17175273unzi_ps
upases84112903u_pases
updives1334713updives
uphills1295233uphills
uppings12257123uppings
uprises92012733uprises
upsides10319633upsides
upsizes18297163upsizes
uptilts934733uptilts
uptimes1177553uptimes
ureides8311103ureides
urines64724123u_rines
utile54718933u_tile_
utricles1037223utricles
voiles94616443_voiles
whiles124418013_whiles
wiles85437873__wiles
yuppies14339263yuppi_es

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.1431249587.4
2DLD Change Limit1340274166.79619721.5
3Display Results4164160.1532719.0
 (SQL Overall)1786914167.09225196.1
 
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.