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

272 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
wries8582774(None) 
bries74942151bries
cries75438401cries
dries64733671dries
fries85535601fries
pries74339531pries
tries55742811tries
wires86034911wires
wried95518561wried
wrier84521751wrier
wriest94419711wriest
writes94420331writes
writs86624381writs
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
cowries124218012cowries
cribs94516752cribs
cried84624282cried
crier74724462crier
criers83918582criers
crimes105521582crimes
cripes105120872cripes
cris66233432cri_s
crises84529432crises
crits75527572crits
curies84934022curies
dies55653522_dies
dories75232362dories
dowries114413982dowries
drees65628522drees
dribs85115062dribs
dried75321382dried
drier64423962drier
driers74516732driers
driest74722752driest
drips85417232drips
drives105117112drives
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
rias45540592_rias
ribes75530172_ribes
ribs65833022_ribs
rices75536152_rices
rides66140812_rides
rids56539542_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
ties45248312_ties
tires55437492tires
tories65435882tories
trees55835762trees
tres46542902tr_es
tribes85119022tribes
trices84826332trices
tried65026912tried
triens65417542triens
trier54328532trier
triers64321522triers
trigs65423062trigs
trikes105419492trikes
trims75021472trims
trines64132562trines
trios55528092trios
tripes85324872tripes
trips74923362trips
trues54925322trues
urges64619912urges
urines64724122urines
varies94330872varies
vies75238622_vies
vires84529682vires
wades95634142wades
wadies105121202wadies
waes76048602w_aes
wages95330932wages
waifs115719872waifs
wails86631482wails
wains86930872wains
wairs86424062wairs
waits88333522waits
waives123714182waives
wakes126633652wakes
wales86142832wales
walies95324522walies
wames106432802wames
wanes85040882wanes
wares88250582wares
warier93722892warier
wariest105122502wariest
waves115633922waves
wavies125019842wavies
waxes155825502waxes
wearies103020222wearies
wees76249122w_ees
weirs84316492weirs
whids125413982whids
whigs125612642whigs
whiles124418012whiles
whims134515332whims
whines125120102whines
whins114922332whins
whips134917082whips
whirs115218092whirs
whites123919882whites
whits115923822whits
wides94832822wides
wifes114522562wifes
wigs84931252w_igs
wiles85437872wiles
wines85546862wines
wins75949172w_ins
wipes104827082wipes
wire75839812wire_
wired95327642wired
wirer85124952wirer
wirers94617892wirers
wirier94215552wirier
wiriest103816852wiriest
wis66552332w_i_s
wise75737342w_ise
wises85633192wises
wiss75630542w_iss
wites85536962wites
wits76044872w_its
wives115328922wives
wizes174723342wizes
woes76440662w_oes
worries104117132worries
worses95522952worses
wraps105617152wraps
wren78221682wr_en
wrens85016242wrens
wrest84925432wr_est
wrick144013392wrick
wricks154610622wricks
wring95920712wring
wrings104012972wrings
wrist84827562wrist
wrists95415642wrists
writ75537912wri_t
write85522832write
writer94416512writer
writers105513492writers
writhes134811702writhes
wryer11489302wryer
wryest12429112wryest
wyes105727502w_yes
wyles114615322wyles
wytes114113432wytes

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 Limit538002721.45037103.4
3Display Results2722720.0634317.5
 (SQL Overall)1786912721.82697859.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.