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

374 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
tries5574281(None) 
bries74942151bries
cries75438401cries
dries64733671dries
fries85535601fries
pries74339531pries
ties45248311t_ies
tires55437491tires
tories65435881tories
trees55835761trees
tres46542901tr_es
tribes85119021tribes
trices84826331trices
tried65026911tried
triens65417541triens
trier54328531trier
triers64321521triers
trigs65423061trigs
trikes105419491trikes
trims75021471trims
trines64132561trines
trios55528091trios
tripes85324871tripes
trips74923361trips
trues54925321trues
wries85827741wries
aeries64737782aeries
amies76837692amies
ares45871022ar_es
arias55438022arias
ariel55228972ariel
ariels65119372ariels
arils58732202arils
arise56436432arise
arises65233802arises
arles56735742arles
armies85123692armies
arses55733872arses
braes75735052braes
brees75632552brees
bribes105918532bribes
brides94423512brides
brie65837902brie_
brief105422602brief
briefs115510072briefs
brier74527402brier
briers85319732briers
brigs85823222brigs
brims94721622brims
brines85028852brines
brins75533972brins
brios74725722brios
bris65539612bri_s
brises84927612brises
briss75824272briss
brits76433082brits
buries84633272buries
caries85147622caries
cires74932912cires
cribs94516752cribs
cried84624282cried
crier74724462crier
criers83918582criers
crimes105521582crimes
cripes105120872cripes
cris66233432cri_s
crises84529432crises
crits75527572crits
curies84934022curies
dies55653522_dies
dories75232362dories
drees65628522drees
dribs85115062dribs
dried75321382dried
drier64423962drier
driers74516732driers
driest74722752driest
drips85417232drips
drives105117112drives
entries71523162entries
ernes55224812ernes
erses55826802erses
eyries93816812eyries
fires85740752fires
flies85630712flies
frees86131392frees
fried95322912fried
frier85225842frier
friers94718932friers
friges104116482friges
frigs96019272frigs
frise85322452frise
frises94124272frises
frites94922482frites
frits86129102frits
frizes184015462frizes
froes86126692froes
furies95126372furies
gies55641422_gies
grees65132472grees
grides84422362grides
grids75321392grids
grief95319782grief
griefs10418722griefs
grigs75318192grigs
grimes94619032grimes
grins65427222grins
gripes94619872gripes
grips85520132grips
grits65529582grits
grues65721962grues
hies74842832_hies
hires86134342hires
ires45639282ir_es
irides74519122irides
irids66417772irids
iris45732552iri_s
irises64221172irises
ivies84215762ivies
juries134120632juries
kris86423602kri_s
krises105016082krises
kyries133411372kyries
lies46454192_lies
lories64933042lories
mires75640882mires
ores46056682or_es
orgies72316092orgies
oriel54920422oriel
oriels64914622oriels
orles55326212orles
paries84742512paries
pies66949602_pies
plies74526512plies
prees75937172prees
prices104524542prices
prides94324182prides
pried84426862pried
prier75027762prier
priers84521192priers
priest84125422priest
prigs85219702prigs
primes104225262primes
prims95425932prims
prise74632612prise
prises84133172prises
priss74623892priss
prizes173819812prizes
rees45364192_rees
reis45343232_reis
res35565042_r_es
retries74129072retries
rias45540592_rias
ribes75530172_ribes
ribs65833022_ribs
rices75536152_rices
rides66140812_rides
rids56539552_rids
riel46432382_riel
riels55121332_riels
rifs74929002_rifs
rigs55137592_rigs
riles55343642_riles
rimes75634542_rimes
rims65936302_rims
rins46153192_rins
ripes75435772_ripes
rips66237432_rips
rise45945232_rise
rises55244042_rises
rites54442552_rites
rives85336002_rives
roes45954142_roes
rues46044482_rues
ryes75529352_ryes
scries85226822scries
series64540972series
shies86136552shies
sires55945372sires
skies95026832skies
spies76037622spies
sris45434152sri_s
sties55132982sties
stories7324272stories
strides84520392strides
strifes104716582strifes
strikes114719092strikes
stripes95320572stripes
strips85719652strips
strives104119372strives
tabes76033922tabes
taces76237802taces
tails55634192tails
tains54936322tains
tajes124920692tajes
takes94437792takes
tales55451372tales
tames75242012tames
tapes75838602tapes
tardies84225862tardies
tares57456562tares
targes74524592targes
tarres64723042tarres
tarries73324262tarries
tates55444982tates
taxes124730822taxes
taxies135817332taxies
tees45353582t_ees
teles54536002teles
terces83921412terces
ternes65422902ternes
terries73425632terries
thief114516302thief
thins85826332thins
this76027382thi_s
threes97117322threes
thrips11299012thrips
thrives134611712thrives
throes97518672throes
tics65729632t_ics
tides64830152tides
tidies74721832tidies
tie36557532t_ie_
tied55535212t_ied
tier44936142t_ier
tiers55526522t_iers
tikes95628902tikes
tiles55542102tiles
tils45739612t_ils
times75630822times
tines54848422tines
tins45251302t_ins
tips66436762t_ips
tire46143352tire_
tired65228902tired
tirls54519802tirls
tiros54524892tiros
tis37056642t_i_s
tits46145042t_its
tobies84521022tobies
todies74223552todies
toes46956442t_oes
toiles63923512toiles
toils54527492toils
toits55327472toits
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
tores55352672tores
torics85118352torics
torses64727952torses
tortes64826052tortes
totes55139682totes
towies93521192towies
traces85329932traces
trades75724502trades
traiks104013712traiks
trails64622512trails
trains64725342trains
traits65121982traits
trams75327672trams
trans54933042trans
trapes85024462trapes
traps75727482traps
trass56226472trass
traves94222742traves
trays85623432trays
tree47745812tr_ee
treed65626732treed
treen55622752treen
treens65317872treens
tref77030992tr_ef
trek86222312tr_ek
treks96016852treks
tress55423162tress
tret46653532tr_et
trets55928022trets
trews86118892trews
trey77228792tr_ey
treys85018212treys
triac74116372triac
triacs83913222triacs
triad65217722triad
triads74513532triads
triages82613792triages
trial54926352trial
trials64319882trials
tribe74420272tribe
trice75127492trice
triced95518672triced
tricep103911072tricep
triceps11267342triceps
trick115420692trick
tricks125319012tricks
triene64316382triene
trienes74118412trienes
trifles103814822trifles
trig55528162tri_g
trigo65716052trigo
trigos74214172trigos
trijet133916552trijet
trijets14308262trijets
trike95320162trike
trill55122932trill
trills64319852trills
trim65329522tri_m
trimer85717152trimer
trimers94615142trimers
trine54734602trine
trined74920712trined
trio45233342tri_o
triodes84012502triodes
triol55521362triol
triols66117802triols
triose64715382triose
trioses75015652trioses
trip66830392tri_p
tripe75425382tripe
triples94616872triples
tripos84014922tripos
trite54730032trite
triter65120592triter
tritest7315272tritest
triunes74311382triunes
trivet93721882trivet
trivets103911582trivets
trogs67022602trogs
trois57226092trois
trokes104019262trokes
trones65629282trones
tropes84824352tropes
trots56629942trots
troves94719112troves
trows88826182trows
troys86418612troys
truces84916332truces
true46725852true_
trued65117692trued
truer54916642truer
truest64816192truest
trugs65516802trugs
truss54916922truss
tubes74826452tubes
tuis44829642tui_s
tules54532792tules
tunes55332192tunes
turves94212692turves
tuxes124316042tuxes
twaes86513662twaes
twier84713292twier
twiers95410162twiers
twigs96911172twigs
twines94717272twines
twins85118982twins
twits86015792twits
tyees86019452tyees
tyes76433372t_yes
tykes125817062tykes
tynes85920302tynes
types105721062types
tyres84725232tyres
urges64619912urges
urines64724122urines
varies94330872varies
vies75238622_vies
vires84529682vires
wires86034912wires
wried95518562wried
wrier84521752wrier
wriest94419712wriest
writes94420332writes
writs86624382writs

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 Limit538003741.45037103.4
3Display Results3743740.1103400.0
 (SQL Overall)1786913741.87395403.6
 
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.