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 “hyraces” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

305 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
hyraces153791(None) 
hyraxes2045701hyraxes
boraces113716852boraces
braces108427772_braces
graces94523492_graces
gyrases11368312gyrases
gyrates113610262gyrates
hayracks2045312hayracks
hydrases15227642hydrases
hydrates15229402hydrates
races74943242__races
thoraces13118932thoraces
traces85329932_traces
abrades10312073abrades
aces67645093___aces
aerates74627483aerates
agrafes1137523agrafes
anlaces92313733anlaces
apyrases1337243apyrases
arames84622573_arames
arracks1387733arracks
arrases71214543arrases
berakes134815773berakes
berates94126853berates
bifaces1448063bifaces
borages103917163borages
boranes93720403boranes
borates94823013borates
boraxes163511633boraxes
brace95629273_brace_
braced115420603_braced
bracer104620583_bracer
bracers114616703_bracers
braches144621223_braches
brachs134415753_brachs
bracts105617773_bracts
braes75735053_bra_es
brakes124923123_brakes
braves115524083_braves
brazes175522193_brazes
bynames14256243bynames
byres104421383byr__es
byrnies12378573byrnies
caracks152211563caracks
carafes125015703carafes
carates95630603carates
carices114220953carices
cerates95428233cerates
charades141310843charades
charases131312753charases
chorales133712873chorales
coracles121811163coracles
cracks144817003_cracks
crakes124921813_crakes
cranes84330753_cranes
crapes104727693_crapes
crases85532313_crases
crates85736053_crates
craves115825393_craves
crazes174720133_crazes
cruces105117543_cruces
curacies12311763curacies
curares94916853curares
curates95323823curates
cycases1437533cycases
cylices14359283cylices
daces85030683__daces
defaces133213403defaces
derates84028883derates
drakes114715863_drakes
drapes95419653_drapes
dryades12395633dryades
durances1158683durances
earaches13411303earaches
effaces15277273effaces
embraces14128863embraces
enfaces122110913enfaces
enlaces92313393enlaces
enrages83114853enrages
erases64425403_erases
eyases94513683ey_ases
eyras84715923eyra__s
eyres84921773eyr__es
eyries93816813eyr_ies
faces106439433__faces
farces115223323far_ces
forages114217273forages
forces114422133for_ces
fracas11311993_fracas
frames115119863_frames
furanes103214863furanes
furnaces1336053furnaces
fyces139813643fy__ces
garages9314113garages
gheraoes1244813gheraoes
glaces94218023_glaces
grace85124543_grace_
graced105217903_graced
grades84926313_grades
grapes95123123_grapes
grates75429883_grates
graves104624003_graves
grazes164519643_grazes
gyrase10508773gyrase_
gyrate104912523gyrate_
gyrated12428413gyrated
gyrenes11267523gyrenes
gyres94820323gyr__es
hacek145411843h__acek
haceks15447863h__aceks
hacks144928713h__acks
hades96035113h__ades
haes77651023h__a_es
hajes155420943h__ajes
hakes126034303h__akes
hales85449843h__ales
hamates122917673hamates
hames106138703h__ames
hances115621283h_ances
hapaxes1936593hapaxes
harass9313943hara_ss
harasses11311033harasses
hardies114923233hardies
hares86255543h__ares
harpies123818313harpies
harries103525493harries
hates86742573h__ates
hatracks1737533hatracks
haves116034873h__aves
haylages1536013haylages
hayrack1945543hayrac_k
hayricks2043763hayricks
hayrides1536883hayrides
hazes174928323h__azes
headraces1546613headraces
hearses104414533hearses
heaves124120303h_eaves
helices12313723helices
heralds1137703heralds
herbages1437083herbages
heredes11313133heredes
heres86245903her__es
heroes94923823her_oes
herpes115517323her_pes
herries104025073herries
hertzes1938293hertzes
hexades18378703hexades
hexanes17319463hexanes
hijacks2333533hijacks
hirees95117293hir_ees
hires86134343hir__es
hirples12149643hirples
hirsles101510073hirsles
hoaxes163611693h_oaxes
homages131011583homages
horahs126313873hora_hs
horas86333093hora__s
hordes104921633hor_des
horses94729343hor_ses
horstes104516113horstes
huaraches1744993huaraches
humates122813193humates
hurdies114015663hurdies
hurdles113613373hurdles
hurlies103315333hurlies
hurries103919653hurries
hurtles103913753hurtles
hybrises1645423hybrises
hydracid1844973hydracid
hydracids1943843hydracids
hydrae13258573hydra_e_
hydrants1585793hydrants
hydras13239313hydra__s
hydrase14287663hydrase_
hydrate14239813hydrate_
hydrated16216953hydrated
hydrides16276943hydrides
hylas114815903hyla__s
hypes135818673hy__pes
hyracoid1745963hyracoid
hyracoids1844243hyracoids
hyrax1838033hyra__x
inlaces92512903inlaces
irades74517393_irades
karates115617473karates
kyacks14416063ky_acks
kyries133411373kyr_ies
laces76141763__laces
lyases95211873ly_ases
lyrate94112103lyrate_
lyrated11388473lyrated
lyres85019963lyr__es
lyrics11357943lyric_s
lysates10317473lysates
maces97139963__maces
maracas11313773maracas
menaces112715523menaces
merces105720743mer_ces
miracles1238333miracles
mirages102213533mirages
morales93619403morales
murices112612283murices
myases113711553my_ases
myiases1235493myiases
myricas1436743myricas
myrtles1235733myrtles
oraches124216473_oraches
oracles93212423_oracles
orates64328613_orates
orrices9129363orrices
outraces102217863outraces
paces96741113__paces
palaces114216453palaces
parades104121463parades
peaces106324083_peaces
phorates13413043phorates
phrases12711463phrases
phytanes1645753phytanes
piracies12312643piracies
pirates93020323pirates
places104323703_places
pomaces132712123pomaces
prances113618773_prances
prases84429023_prases
prates84633163_prates
praxes156215183_praxes
prices104524543_prices
pyrans11411063pyra_ns
pyrenes123511223pyrenes
pyres105523883pyr__es
pyrexes19305833pyrexes
pyrites12812203pyrites
pyrones123113303pyrones
pyropes142210193pyropes
race66746263__race_
raced87635313__raced
racer75233023__racer
racers84725433__racers
racks115028853__racks
rages64539443__rages
rajes125022783__rajes
rakes94440353__rakes
rales54947493__rales
rances84625443__rances
rapes75740723__rapes
rares55247443__rares
rases55447213__rases
rates55352013__rates
raves85441973__raves
raxes124729393__raxes
razes145032703__razes
refaces123216743refaces
relaces93420883relaces
reracks132310533reracks
retraces101417263retraces
rices75536153__rices
rubaces1139303rubaces
sarapes94617743sarapes
scrapes116217663scrapes
seracs84418573serac_s
serapes95218103serapes
solaces93116133solaces
spaces104722633_spaces
spruces113810503spruces
strafes104515993strafes
strakes114218073strakes
styraxes1833493styraxes
subraces12313033subraces
surfaces1338673surfaces
syces106416463sy__ces
taces76237803__taces
tenaces92814513tenaces
terces83921413ter_ces
terraces102712223terraces
thoraxes1896353thoraxes
thraves13469713thraves
thyrses1335013thyr_ses
tirades8311723tirades
trace75829613_trace_
traced94821583_traced
tracer84820233_tracer
tracers94917833_tracers
tracks124818843_tracks
tracts85019073_tracts
trades75724493_trades
trances93919643_trances
trapes85024463_trapes
traves94222743_traves
trices84826333_trices
truces84916333_truces
turacos938623turacos
tyrants1037453tyrants
tyres84725233tyr__es
unbraces12229413unbraces
unlaces92513623unlaces
uprates93814863uprates
urares64519093_urares
urases63723563_urases
urates65027763_urates
varices123313573varices
vivaces1536413vivaces
wheyfaces2351523wheyfaces
wracks154711113_wracks
yacks144419813_y_acks
zymases21938333zymases

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273055.84322938.0
3Display Results3053050.1102772.7
 (SQL Overall)1786913056.10929250.5
 
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.