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 “piers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

305 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
piers7592633(None) 
biers76225221biers
kiers95320091kiers
liers55130401liers
peers75130271peers
pier66035291pier_
pies66949601pie_s
pikers124717391pikers
pipers104318661pipers
pliers84715151pliers
priers84521191priers
spiers84421741spiers
tiers55526521tiers
viers85621951viers
agers65027852agers
aiders74524632aiders
aimers84621912aimers
airers64922312airers
airs46447422ai_rs
aivers94822322aivers
apers76629132apers
avers85127312avers
beers75628392beers
biders94822802biders
bier65531822bier_
bikers124517552bikers
biners85023632biners
birrs74917102birrs
biters83925232biters
briers85319732briers
ciders94620082ciders
cires74932912cires
citers85022972citers
copiers114215962copiers
criers83918582criers
deers64930522deers
dicers94720742dicers
dies55653522die_s
diets66026642diets
dikers114418792dikers
dimers94321092dimers
diners75525952diners
divers105024962divers
doers65225712doers
driers74516732driers
dyers96617132dyers
egers65120372egers
eiders74321362eiders
epimers11109492epimers
ers36046282__ers
ewers86018822ewers
eyers86521332eyers
fiars86720832fiars
fibers114717522fibers
fiefs116213702fiefs
fiery114714792fiery
fifers125414922fifers
filers94623722filers
firers94922682firers
fires85740752fires
firs76637712fi_rs
fivers124420922fivers
fixers165112982fixers
fliers94417192fliers
friers94718932friers
gibers95114662gibers
gies55641422gie_s
givers104817712givers
goers65520252goers
heirs85618562heirs
hers75844872_hers
hiders104919652hiders
hies74842832hie_s
hikers135014352hikers
hirers94518062hirers
hires86134342hires
hoers85724922hoers
ires45639282_ires
jeers124818132jeers
jibers155912882jibers
jivers164515642jivers
keirs95313672keirs
kiefs126112202kiefs
kier86526802kier_
kirs85831732ki_rs
kiters105218582kiters
leers54828982leers
liars54723162liars
libers84721432libers
liens56525502liens
lier45942462lier_
lies46454192lie_s
lieus56218482lieus
lifers95617842lifers
ligers75022022ligers
likers104620912likers
liners65428842liners
liters65429872liters
livers94927822livers
miens76118302miens
milers84625162milers
mimers105520182mimers
miners84126632miners
mires75640882mires
mirs66940562mi_rs
misers85025702misers
miters84328772miters
mixers154513562mixers
niters64624202niters
oilers64721192oilers
omers76923192omers
osiers63412792osiers
overs85224792overs
oyers87620882oyers
pacers105124542pacers
pagers94423252pagers
pairs75325832pairs
paniers94717332paniers
papers105125322papers
parers85530742parers
pares77164482pares
parrs75928672parrs
pars67560792p_ars
paters84935822paters
pavers115021822pavers
pawers114818782pawers
payers114621822payers
pears75138612pears
peas65755062p_eas
pecs84634102p_ecs
peds75835242p_eds
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peer66238352peer_
peery105719442peery
pees65257372p_ees
pegs75531762p_egs
pehs95625762p_ehs
peins76128062peins
pens65649642p_ens
peps85134512p_eps
per56353092p_er_
pere66450262p_ere
peres76246642p_eres
peri65636972p_eri
peris75537072p_eris
perk106232842p_erk
perks115325802p_erks
perm85834632p_erm
perms95524512p_erms
perp89029892p_erp
perps95521482p_erps
perse75429522p_erse
pert66759322p_ert
perv97224812p_erv
pervs105117372p_ervs
pes57259782p_e_s
peters86624592peters
pets66248332p_ets
pews95731532p_ews
pians75126962pians
pias66542552pi_as
picas94626522picas
pickers153718092pickers
picks135226142picks
pics85633912pi_cs
pie55457402pie__
piece96717992piece
piecers114112252piecers
pieces104217272pieces
pied75035362pie_d
pierce104010392pierce
pierces113411192pierces
pieta75421752pieta
pietas84516502pietas
piety105817302piety
pigs76634222pi_gs
pikas114218092pikas
piker115622842piker_
pikes115031032pikes
pikis115116392pikis
piles74742612piles
pileus84514942pileus
pilfers1238962pilfers
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pimas94725102pimas
pimps114616982pimps
pinas75434452pinas
pincers113916502pincers
pinders103720472pinders
pinery115214282pinery
pines76048862pines
pingers104020732pingers
pings85830882pings
pinkers134118602pinkers
pinks115729382pinks
pinners93518592pinners
pins65558452pi_ns
pints75936222pints
pions75826392pions
pious74621272pious
piper96523192piper_
pipes96030142pipes
pipets105714772pipets
pips85837132pi_ps
pirn67128372pi_rn
pirns76020092pirns
pis56362032pi__s
pishers123815752pishers
pisos76021062pisos
piss65033332pi_ss
pissers95014752pissers
pitas77427672pitas
piths105817542piths
pitiers93812652pitiers
pits66348742pi_ts
pixels15478532pixels
pixes144323172pixes
pleas75627032pleas
plebs95814582plebs
plews105415352plews
plier75221282plier_
plies74526512plie_s
plyers114912982plyers
poems95715552poems
poets76024442poets
poisers94214432poisers
pokers124617922pokers
polers84225642polers
pores75849032pores
posers84223972posers
pours74623182pours
powers113822322powers
prees75937172prees
preps96220692preps
press75425952press
preys105717782preys
pricers113915062pricers
prier75027762prier_
pries74339532prie_s
primers114215672primers
priors83914482priors
prizers183911842prizers
pryers115012242pryers
pulers83820282pulers
purrs75320432purrs
purs65641042p_urs
pyes95528992pye_s
pyres105523882pyres
rapiers95012872rapiers
ricers84120992ricers
riders74123902riders
riels55121332riels
rimers84522552rimers
risers64624782risers
rivers94626542rivers
ruers515019412ruers
seers55136382seers
sers45746652_sers
shiers94921752shiers
sieurs659042sieurs
sires55945372sires
sirs44338332si_rs
sivers95324152sivers
sizers155215812sizers
skiers104713692skiers
speers85019952speers
speirs85013232speirs
spicers113815552spicers
spiders103914412spiders
spiels85317952spiels
spier75728032spier_
spies76037622spie_s
spikers135311992spikers
spires84628112spires
suers55128482suers
tier44936142tier_
ties45248312tie_s
tigers75616502tigers
tilers63523492tilers
timers84420992timers
tires55437492tires
titers64526402titers
triers64321522triers
twiers95410162twiers
tyers86220052tyers
uppers102912282uppers
users55817572users
veers84521362veers
vier75428152vier_
vies75238622vie_s
views11489642views
vipers114914532vipers
vires84529682vires
vivers124717362vivers
weirs84316492weirs
wipers115416082wipers
wirers94617892wirers
wires86034912wires
wivers125320802wivers
yirrs8469192yirrs

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538003052.25023911.1
3Display Results3053050.0803812.5
 (SQL Overall)1786913052.42373747.8
 
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.