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

316 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
ports7593459(None) 
borts76735451borts
forts86034451forts
morts75533561morts
orts46538331_orts
parts77743371parts
poets76024441poets
pores75849031pores
porks115124141porks
porns75527341porns
port66059631port_
posts75228781posts
pots66452361po_ts
pouts75530321pouts
sorts54536661sorts
sports84619181sports
torts56138121torts
worts88631181worts
aborts84916182aborts
airts55626342airts
aorta55922572aorta
aortas65417782aortas
aport75432172aport_
arts49650262_arts
boarts84716872boarts
boats75635152boats
bolts76232112bolts
boots75837972boots
boras75938302boras
bores76448252bores
borks115727702borks
bort65960962bort_
borty105522832borty
bortz165722202bortz
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
carts78946292carts
coats75635002coats
colts76633292colts
coots75636842coots
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442cor_s
costs77231142costs
cots68054842co_ts
courts84216172courts
darts67635732darts
deports105012882deports
dirts66824462dirts
doats65224882doats
doits66223672doits
dolts65626312dolts
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
dorty96220812dorty
dots55647662do_ts
exports1647982exports
farts88336842farts
fonts86124752fonts
foots85528282foots
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
forms105327052forms
fort76456442fort_
forte86131462forte
fortes95327182fortes
forth116222672forth
fortis95418612fortis
forty114824272forty
girts65423622girts
goats65527302goats
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gouts64826172gouts
grots65025852grots
harts88441592harts
holts85627912holts
hoots84830252hoots
horas86333102horas
horns86125332horns
horst85833512horst
horsts95817512horsts
hosts85526702hosts
hots78349332ho_ts
hurts86922822hurts
imports11309622imports
jolts125018882jolts
jots116336142jo_ts
karts97630112karts
koras95927112koras
korats105416062korats
kors85933012kor_s
lofts85518362lofts
loots55431422loots
lords64923502lords
lores55045402lores
loris55329152loris
lots47652092lo_ts
louts56330272louts
marts77442232marts
moats75827642moats
molts76032092molts
moots75831662moots
moras76438782moras
mores76249642mores
morns75527442morns
mors65950062mor_s
mort66758832mort_
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
nerts55924982nerts
noris54928272noris
norms76019312norms
north86018272north
norths96812322norths
nowts86915862nowts
oats46554212_oats
oots46446442_oots
opts68124742_opts
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
ors35750112_or_s
ort39465232_ort_
outs45746962_outs
pacts95125802pacts
pants76536922pants
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792par_s
part65967462part_
party106630612party
pasts75936502pasts
pats66460852p_ats
peats76140192peats
pelts76128812pelts
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pert66759322pert_
pervs105117372pervs
pests75933272pests
pets66248332p_ets
phots105418502phots
phuts104613502phuts
pints75936222pints
pirns76020092pirns
pits66348742p_its
plats75531372plats
plots75025672plots
pocks135022962pocks
pods76540152po_ds
poems95715552poems
poet65552902poet_
points85618532points
pois66539042po_is
pokes116133012pokes
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562po_ls
polys105718762polys
pomes94833932pomes
pomos95321582pomos
pomps115316192pomps
poms87037742po_ms
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602po_ns
pontes83627852pontes
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
pooris83916842pooris
poos65949112po_os
popes95933812popes
pops86340952po_ps
porch125918622porch
pore66451262por_e
pored85234512pored
porgy116916122porgy
porism104518062porism
pork106929682por_k
porky145019332porky
porn65636022por_n
porno75120652porno
pornos85015252pornos
porny106020192porny
porose84818742porose
porous84419482porous
portal84218462portal
portals94015562portals
ported94223242ported
porter84224412porter
porters93722702porters
portly114713402portly
poses74642762poses
posits85718712posits
post67953362post_
pot58078432po_t_
potsy105815612po_tsy
potto75320942potto
pottos84615872pottos
potty105621002potty
poufs105616062poufs
poults84613482poults
pours74623182pours
pout65752552pout_
pouty107018812pouty
pows95537662po_ws
poxes145325722poxes
prats76333392prats
proas75028802proas
prods85523552prods
profs105120892profs
progs86624152progs
proms95426412proms
props95726882props
pros65742782p_ros
pross76529402pross
prost75434102prost
prows106327012prows
punts75828002punts
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
purty105019402purty
puts65641752p_uts
putts75719272putts
pyres105523882pyres
pyros105718292pyros
reports94916212reports
roots55933672roots
rots46454092ro_ts
routs57133412routs
shorts95321742shorts
skorts104211302skorts
snorts64116502snorts
softs85019232softs
soots55536212soots
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028422sorns
sort46264812sort_
sorta57125412sorta
sorus54527582sorus
sots45552452so_ts
spirts85317132spirts
spores84726612spores
sport75935982sport_
sporty115112492sporty
spots74424112spo_ts
spouts85115112spouts
spurts84814972spurts
tarts57242022tarts
tofts84919242tofts
toits55327472toits
toots55331872toots
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382tor_s
tort46967462tort_
torta55925352torta
tortas64918252tortas
torte55431702torte
tortes64826052tortes
torus54329762torus
tots46654122to_ts
touts54830392touts
trots56629942trots
verts85724732verts
volts85421292volts
warts814840402warts
whorts125111432whorts
wonts87621542wonts
words95425072words
works125621902works
worms105320762worms
worst86330132worst
worsts96014332worsts
wort76654752wort_
worth117120522worth
worths127812892worths
wots76342892wo_ts
yores85031322yores
yurts87216532yurts
zoris145320012zoris

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.313570897.8
2DLD Change Limit538003161.58034050.6
3Display Results3163160.0933397.8
 (SQL Overall)1786913161.98689975.3
 
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.