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

329 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
trans5493304(None) 
brans75437431brans
grans64832541grans
tans46154811t_ans
tarns56433951tarns
trains64725341trains
trams75327671trams
trank96222421trank
tranks104017761tranks
tranq145416891tranq
tranqs155210311tranqs
traps75727481traps
trass56226471trass
trays85623431trays
alans55636172alans
araks94820882araks
atmans84413962atmans
azans146516882azans
bans66555132_bans
barns76335142barns
beans75734692beans
brads85528292brads
braes75735052braes
brags85625102brags
brains85125472brains
bran65740382bran_
brand85124492brand
brands95118942brands
brank115222282brank
branks124817382branks
brant74742172brant
brants85723052brants
bras65746452bra_s
brass75428022brass
brats75336012brats
brawns115614082brawns
braws106425192braws
brays106723112brays
brens75823362brens
brins75533972brins
burans85019302burans
cans65050842_cans
carns75937562carns
clans75031012clans
crabs95421392crabs
crags85622572crags
crams96229152crams
crane75331602crane
cranes84330752cranes
crank114819612crank
cranks125015312cranks
craps95328642craps
crass76328042crass
craws105723122craws
cyans105714812cyans
dans56748142_dans
darns66927892darns
deans66131392deans
drabs85119672drabs
drags75521112drags
drains73719402drains
drams86025832drams
drank104816202drank
drats66628372drats
draws95119372draws
drays95819772drays
earns55927562earns
elans55527752elans
eras45441502era_s
erns45428222er_ns
fans76247362_fans
flans85327972flans
frags96322162frags
franc104615412franc
francs114112192francs
frank124417512frank
franks134912732franks
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
frons86124042frons
furans94515952furans
glans65125832glans
grabs85719692grabs
grads75625752grads
grains74223092grains
grams85327312grams
gran56335012gran_
grana65722092grana
grand75122692grand
grands84218242grands
grant64840022grant
grants73722472grants
grass66125202grass
grays95621332grays
grins65427222grins
groans74815062groans
guans64419442guans
irons55324132irons
jeans126022112jeans
karns96624142karns
khans124615172khans
koans95818622koans
leans55536252leans
loans56026462loans
lorans65117602lorans
mans66354532_mans
means75831222means
moans74624362moans
naans55815252naans
nans46139392_nans
orals55826482orals
orang65119942orang
orangs74116032orangs
organs7912912organs
pans65855722_pans
peans75437642peans
pians75126962pians
plans75731272plans
prams96125512prams
prang84820322prang
prangs94816232prangs
prank115019452prank
pranks124814722pranks
praos74923562praos
prats76333392prats
praus74621752praus
prawns11509022prawns
prays105022432prays
pyrans11411062pyrans
rads56046602_rads
rags55448372_rags
rains55140232_rains
rais45252622_rais
rams65950772_rams
ran38266612_ran_
rand55839562_rand
rands65930452_rands
rang56939152_rang
rani46640102_rani
ranis55235832_ranis
rank85135522_rank
ranks95225732_ranks
rant45864672_rant
rants55935342_rants
raps66247732_raps
ras37575392_ra_s
rats46260372_rats
raws75238212_raws
rays77642352_rays
rins46153192_rins
roans54926442roans
runs46438072_runs
sans45153352_sans
sarans64224432sarans
scans74625102scans
spans74528732spans
strains74218152strains
strand74514822strand
strands83711952strands
strang75718312strang
straps87721782straps
strass67117222strass
straws98718672straws
strays96417932strays
swans84625012swans
tabs66842982t_abs
tads57143942t_ads
tags55545232t_ags
tains54936322tains
tams67247932t_ams
tan37167562t_an_
tang56138662t_ang
tangs65028342t_angs
tank85134012t_ank
tanks94624732t_anks
tansy84514932t_ansy
taos45541002t_aos
taps66050672t_aps
tares57456562tares
tarn46842722tarn_
taros55640822taros
tarpans92513532tarpans
tarps76527112tarps
tars46763952t_ars
tartans72615822tartans
tarts57242022tarts
tarzans16329922tarzans
tas38477102t_a_s
tass45640572t_ass
tats46858132t_ats
taus46342732t_aus
tavs75630972t_avs
taws75641592t_aws
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492tea_s
teats55636812teats
teens56227482teens
tens45647412t_ens
terais64023502terais
terns55226872terns
than76128772than_
thane86122532thane
thanes94918982thanes
thank125817802thank
thanks134313132thanks
thaws116515462thaws
thens85921832thens
thins85826322thins
thraws129211102thraws
tins45251302t_ins
titans63414912titans
toads65621062toads
tolans64319272tolans
tomans85419132tomans
tons46553052t_ons
toons55027532toons
torahs95115642torahs
toras55540372tora_s
towns86018882towns
trace75829612trace
traces85329932traces
track114823012track
tracks124818842tracks
tract75635712tract
tracts85019072tracts
trad55630912tra_d
trade65026042trade
trades75724492trades
tragi64717172tragi
tragus749222tragus
traik95418202traik
traiks104013712traiks
trail55126772trail
trails64622512trails
train56529112train
trait56940842trait
traits65121982traits
tram67034552tra_m
tramp96319772tramp
tramps105114452tramps
trance84718762trance
trances93919642trances
tranny94210862tranny
transit7317162transit
transom948822transom
trap67532802tra_p
trapans92812462trapans
trapes85024462trapes
trapt76433392trapt
trash86119762trash
trave85223032trave
traves94222742traves
trawl84915872trawl
trawls94412392trawls
tray77632592tra_y
treads74817912treads
treats64821692treats
treens65317872treens
trees55835762trees
treks96016852treks
trend64817452trend
trends75513542trends
trepans92311592trepans
tres46542902tr_es
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
triacs83913222triacs
triads74513522triads
trials64319882trials
triens65417542triens
tries55742812tries
trigs65423062trigs
trims75021472trims
trine54734602trine
trines64132562trines
trios55528092trios
trips74923362trips
troaks104410592troaks
trogs67022602trogs
trois57226092trois
trona54118952trona
tronas63816892tronas
trone55131862trone
trones65629282trones
trots56629942trots
trows88826182trows
troys86418612troys
truant6315782truant
truants738152truants
trues54925322trues
trugs65516802trugs
trunk94713042trunk
trunks10429752trunks
truss54916922truss
tsars56717102tsars
tunas54224122tunas
tuns45138662t_uns
turbans939562turbans
turns55623232turns
twaes86513662twaes
twains95811182twains
twang94511852twang
twangs10358092twangs
twas76824082twa_s
twats86616602twats
twins85118982twins
tyrant9315332tyrant
tyrants1037452tyrants
tzars144914272tzars
ulans54921302ulans
urns46323892ur_ns
vans76236722_vans
wans76452262_wans
warns87231002warns
weans85326742weans
wrang94716112wrang
wrangs104611912wrangs
wraps105617152wraps
wrens85016242wrens
yarns85621792yarns
yeans86624882yeans
yuans84613322yuans

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 Limit538003292.25023911.1
3Display Results3293290.1901731.6
 (SQL Overall)1786913292.53370545.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.