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

348 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
pants7653692(None) 
ants47243471_ants
cants77036941cants
hants86335401hants
pacts95125801pacts
paints85921831paints
panes76148691panes
pangs84628661pangs
pans65855721pan_s
pant66061251pant_
panto76129411panto
pantos85222741pantos
panty105929301panty
parts77743371parts
pasts75936501pasts
pats66460851pa_ts
pints75936221pints
plants84921801plants
punts75828001punts
rants55935341rants
wants87932211wants
acts66929862_acts
aits46355532_aits
alants67722022alants
alts46639902_alts
anas46649862_anas
ands57833612_ands
anes45255932_anes
anis45746462_anis
ant37270782_ant_
anta46839582_anta
antas55432032_antas
ante46538902_ante
antes56334322_antes
anti45536362_anti
antis55033312_antis
antsy85712792_antsy
anus47131112_anus
arts49650262_arts
aunts55227632aunts
bahts105617802bahts
baits76630582baits
bands85233422bands
banes74945582banes
bangs85627772bangs
banks115527902banks
banns75321232banns
bans66555132ban_s
banty106624002banty
basts75936932basts
bats66962332ba_ts
batts76727562batts
bents76033692bents
bints76130182bints
brants85723052brants
bunts75729802bunts
canes75350372canes
cans65050842can_s
canst74932212canst
cant66362022cant_
canto74931012canto
cantos84826972cantos
cantus85117762cantus
canty105226802canty
carts78946292carts
casts77237792casts
cats66356342ca_ts
cents74730332cents
chants115020392chants
cunts76125122cunts
dangs75623202dangs
dans56748142dan_s
darts67635732darts
daunts75014082daunts
dauts67822242dauts
dawts97216122dawts
dents65031802dents
dints67431312dints
dopants1038432dopants
dunts65828412dunts
easts57530322easts
eats47054872ea_ts
epacts105010392epacts
facts107021892facts
faints94818782faints
fanes84639892fanes
fangs96224072fangs
fanos85926502fanos
fans76247362fan_s
farts88336842farts
fasts86429682fasts
fats76252502fa_ts
fonts86124752fonts
gaits65726012gaits
gangs76222572gangs
gasts66628632gasts
gats56753442ga_ts
gents65729612gents
giants74713502giants
gnats65217712gnats
grants73722472grants
haets86525122haets
hafts116219462hafts
haints94417582haints
halts85230102halts
hands95327382hands
hangs95726722hangs
hanks126226862hanks
hant75461582hant_
harts88441592harts
hats76858252ha_ts
haunts95614392haunts
hents87330742hents
hints87330622hints
hunts86826172hunts
janes124928122janes
janty156816962janty
jaunts137511882jaunts
kanas95326912kanas
kanes95529372kanes
karts97630112karts
kats85944332ka_ts
lands65426902lands
lanes54946792lanes
lasts57731262lasts
lats45962702la_ts
lints57137192lints
lunts55826902lunts
malts76331752malts
manas76240422manas
manats84623462manats
manes76648952manes
manos74933612manos
mans66354532man_s
manta75629902manta
mantas85725362mantas
mantes84430782mantes
mantis83926032mantis
manus75924922manus
marts77442232marts
masts77035762masts
mats65460282ma_ts
matts76829182matts
mauts75927192mauts
mints76834042mints
nanas55928632nanas
nans46139392nan_s
oasts56529182oasts
oats46554212oa_ts
pacas96029402pacas
paces96741112paces
packs135528932packs
pacs85842182pa_cs
pact86648722pact_
padis86227142padis
pads76742952pa_ds
pages85235072pages
paiks114719852paiks
pails75833062pails
pains75138282pains
paint75443692paint_
painty114714752painty
pairs75325832pairs
pales75753802pales
palets85122312palets
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pa_ls
pams85641762pa_ms
pan58466442pan__
panda85022612panda
pandas95521962pandas
pandits103914212pandits
pandy115021172pandy
pane64950282pan_e
paned85437182paned
panel76023622panel
panels84716522panels
pang75336282pan_g
panga85323532panga
pangas99921102pangas
panic93923902panic
panics103815362panics
panne76623652panne
pannes85522852pannes
pansy105717972pansy
panted95024822panted
pantie84326472pantie
panties94230932panties
pantry115014102pantry
papas94927492papas
paps86443452pa_ps
paras76143042paras
pards85634332pards
parents93418122parents
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792pa_rs
part65967462part_
party106630612party
pas58775742pa__s
pases75346502pases
pass65239952pa_ss
past65959012past_
pasta76624532pasta
pastas85422872pastas
paste74932952paste
pastes85233912pastes
pastis84924322pastis
pasty105725052pasty
pat58089462pa_t_
pate65350462pa_te
patents94815202patents
pates76047892pates
path99134912pa_th
paths105521382paths
patsy105717202pa_tsy
patty104723612patty
paty95234562pa_ty
paves104833922paves
pavis106422732pavis
pawls105617662pawls
pawns108818132pawns
paws96038182pa_ws
paxes144928422paxes
pays95940222pa_ys
peans75437642pean_s
peanuts936992peanuts
peats76140192peats
pedants10310112pedants
pelts76128812pelts
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pen_s
pent66559072pent_
pests75933272pests
pets66248332p_ets
phots105418492phots
phuts104613502phuts
pianos84315932pianos
pians75126962pian_s
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pinots85920272pinots
pins65558452pin_s
pint66963172pint_
pinta75727052pinta
pintas85021392pintas
pinto75625752pinto
pintos86021292pintos
pits66348742p_its
plaints94012052plaints
plaits83816472plaits
planes85028082planes
planets93914082planets
planks124116752planks
plans75731272plan_s
plant75437112plant_
plats75531372plats
plots75025672plots
poets76024442poets
points85618532points
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602pon_s
pontes83627852pontes
ports75934592ports
posts75228782posts
pots66452362p_ots
pouts75530322pouts
prangs94816232prangs
pranks124814722pranks
prats76333392prats
prints84320102prints
punas74826752punas
pungs85422222pungs
punks114822682punks
puns66641482pun_s
punt65747202punt_
punto75121322punto
puntos85915792puntos
punty106021612punty
puts65641752p_uts
putts75719272putts
qanats154112812qanats
qats135331342qa_ts
quants153614142quants
rafts87820632rafts
rands65930452rands
ranis55235832ranis
ranks95225732ranks
rant45864672rant_
rats46260372ra_ts
rents55935182rents
runts55927632runts
saints65122422saints
salts55431882salts
sands65228582sands
sanes55649072sanes
sans45153352san_s
santo56227282santo
santos64421832santos
scants85219722scants
slants64819082slants
spaits85017472spaits
spanks124514122spanks
spans74528732span_s
spats75031382spa_ts
tacts76524122tacts
taints64520532taints
tangs65028342tangs
tanks94624732tanks
tans46154812tan_s
tanto55724942tanto
tarts57242022tarts
tats46858132ta_ts
taunts65715662taunts
tauts56125512tauts
tents56434212tents
tints56030922tints
vanes85130972vanes
vangs96319582vangs
vans76236722van_s
vasts86423772vasts
vats76841742va_ts
vaunts95212622vaunts
vents86125932vents
wafts116920552wafts
waits88333522waits
wands96425482wands
wanes85040882wanes
wanks126124482wanks
wans76452262wan_s
want76156162want_
warts814840402warts
wasts87433672wasts
wats77555882wa_ts
watts86923092watts
wonts87621542wonts
yangs95618692yangs
yanks125316572yanks

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 Limit538003482.42322203.9
3Display Results3483480.0933741.9
 (SQL Overall)1786913482.60968490.2
 
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.