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

341 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
borts7673545(None) 
aborts84916181aborts
boarts84716871boarts
boats75635151boats
bolts76232111bolts
boots75837971boots
boras75938301boras
bores76448251bores
borks115727701borks
bort65960961bort_
borty105522831borty
bortz165722201bortz
bots66453951bo_ts
botts75224861botts
bouts75131311bouts
forts86034451forts
morts75533561morts
orts46538331_orts
ports75934591ports
sorts54536661sorts
torts56138121torts
worts88631181worts
abort76133582abort_
abortus9397912abortus
airts55626342airts
aorta55922572aorta
aortas65417782aortas
arts49650262_arts
bahts105617802bahts
baits76630582baits
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092bar_s
basts75936932basts
bats66962332b_ats
batts76727562batts
beats76042242beats
beets76131442beets
belts75931162belts
bents76033692bents
berets85822522berets
bergs84718042bergs
berks115423122berks
berms95323662berms
berth104917882berth
berths114712422berths
bests75932612bests
bets67051442b_ets
bhoots11459912bhoots
bhuts105812952bhuts
bints76130182bints
bionts8612392bionts
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
birth105619872birth
births115713602births
bits66148162b_its
bitts75022592bitts
blats75132502blats
blets75324942blets
bloats85215762bloats
blots75626172blots
blurts84412642blurts
boards94616932boards
boars75229602boars
boart78835932boart_
boas66150832bo_as
boast75935702boast
boasts85017922boasts
boat66360312boat_
bobs86340652bo_bs
bocks134526572bocks
bodes84935102bodes
bods76244712bo_ds
boffs134915502boffs
bogarts1047742bogarts
bogs75742752bo_gs
bogus85616472bogus
bohos105618252bohos
boils75427192boils
boite74426322boite
boites84322702boites
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolt66254172bolt_
bolus79125542bolus
bombs115818822bombs
bonds86126842bonds
bones76446532bones
bongs87828422bongs
bonks116326462bonks
bonus75324322bonus
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032bo_os
boost75132472boost
boosts86115012boosts
boot67759372boot_
booth105522012booth
booths115313792booths
booty106125912booty
bops86037982bo_ps
bora66141632bor_a
boral75831702boral
borals86721912borals
borate85026152borate
borates94823012borates
borax145918722borax
bore66051332bor_e
boreas85421732boreas
bored85034302bored
borer75131272borer
borers85122682borers
boric98024222boric
bork106933822bor_k
born67338412bor_n
borne77926792borne
boron76727142boron
borons85520542borons
borshts1266542borshts
bortzes1838222bortzes
bos57966812bo__s
bosks115218852bosks
boss65938342bo_ss
bot59680402bo_t_
bota66236502bo_ta
botas75328782botas
both96533432bo_th
bott66548572bo_tt
bourgs9459992bourgs
bourns84114062bourns
bout66353292bout_
bowls106121432bowls
bows96242862bo_ws
boxes145625072boxes
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
bras65746452b_ras
brats75336012brats
bris65539612b_ris
brits76433082brits
broos75126412broos
bros65635662b_ros
broth106521092broth
broths115013922broths
brows105425982brows
bruts75922952bruts
bunts75729802bunts
buras74736302buras
burbs95423492burbs
burds84626062burds
burets84321262burets
burgs84924092burgs
burls74228852burls
burns74926782burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
burst75332242burst
bursts85116242bursts
busts75227692busts
buts67247692b_uts
butts75824252butts
byres104421382byres
byrls105711232byrls
carts78946292carts
coats75635002coats
colts76633292colts
coots75636842coots
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442cor_s
costs77231142costs
cots68054842co_ts
courts84216172courts
darts67635732darts
dirts66824462dirts
doats65224882doats
doits66223672doits
dolts65626312dolts
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
dorty96220812dorty
dots55647662do_ts
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
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
obits74617552obits
oots46446442_oots
opts68124742_opts
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
ors35750112_or_s
ort39465232_ort_
outs45746962_outs
parts77743372parts
poets76024442poets
pores75849032pores
porks115124142porks
porns75527342porns
port66059632port_
posts75228782posts
pots66452362po_ts
pouts75530322pouts
roots55933672roots
rots46454092ro_ts
routs57133412routs
shorts95321742shorts
skorts104211302skorts
snorts64116502snorts
softs85019232softs
soots55536212soots
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028422sorns
sort46264812sort_
sorta57125412sorta
sorus54527582sorus
sots45552452so_ts
sports84619182sports
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 2 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 Limit538003411.39038705.0
3Display Results3413410.0933666.7
 (SQL Overall)1786913411.79699493.9
 
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.