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

214 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
fractus1214659(None) 
fractur12135561fractur
fracturs13146311fracturs
bracts105617772bract_s
cactus104912232_cactus
facts107021892f_act_s
flatus94310782fla_tus
fracas11311992frac_as
fractal1237622fractal
fractals1346132fractals
fracted1339372fracted
fracti1139962fract_i
fractious1456142fractious
fracture13147122fracture
fractures14147232fractures
fraktur14153032fraktur
frakturs15163262frakturs
frats86829672fra_t_s
rectus83314632_rectus
rictus8379192_rictus
tracts85019072tract_s
abacus10349763abac_us
acts66929863__act_s
araceous1049183araceous
arbutus944843arbutus
arcus76918863ar_c_us
bracers114616703bracers
braces108427773brac_es
braches144621223braches
brachs134415753brac_hs
bract96332723bract__
bracted12410933bracted
brants85723053brant_s
brats75336013bra_t_s
cantus85117763_cantus
coacts105314333coact_s
cracks144817003crac_ks
crackup1743563crackup
crackups1843123crackups
crafts115312743craft_s
crates85736063cra_tes
crocus104813173croc_us
drachms1534253drachms
drafts105012533draft_s
drats66628373dra_t_s
enacts84012973enact_s
epacts105010393epact_s
erects84116183erect_s
eructs83610793eruct_s
exactas16336433exactas
exacts15359613exact_s
facers115519443f_acers
faces106439433f_ac_es
facets116316653f_acets
faceup1334893f_aceup
facias113415803f_acias
facies113921593f_acies
fact97142543f_act__
factful1536373f_actful
factious13239243f_actious
factor11911453f_actor
factors12912123f_actors
factual1246723f_actual
facture12108923f_acture
factures13129023f_actures
faiths124610273f_aiths
famous11412393f_amous
farcers124713443farcers
farces115223323farc_es
farceur12525273farceur
farceurs13464723farceurs
farcies125317883farcies
farts88336843f_art_s
fasts86429683f_ast_s
fates85139233f_a_tes
fats76252503f_a_t_s
favus114311733f_a_vus
feasts95116093feast_s
feats86432753fea_t_s
fetus85816543f__etus
fiacres1237253fiacres
fiats85324483fia_t_s
fichus14388113f_ichus
ficus105015493f_ic_us
flacks154114533flac_ks
flacons1238053flacons
flats86429743fla_t_s
flautas1036153flautas
floccus1443653floccus
focus105815883f_oc_us
foetus958523f_oetus
frabjous2042633frabjous
fracases1336993fracases
fraction1359483fraction
fractions1449103fractions
fractural1444553fractural
fractured15125043fractured
fracturer14134623fracturer
fracturers15123203fracturers
fraenum1255703fraenum
fraenums1353403fraenums
frags96322173fra__gs
frails93716473fra_ils
fraises104215693fraises
framers125113823framers
frames115119863fra_mes
francium1545623francium
franciums1644413franciums
francs114112193fra_ncs
franks134912733fra_nks
frantic12310363frantic
frappes14328383frappes
fraps105620553fra__ps
frass85321123fra__ss
frasses104314513frasses
frat75648543fra_t__
frater94520593fra_ter
fraters103517213fraters
fraud939863fra__ud
frauds1036753fra_uds
frays116920103fra__ys
frazils1956123frazils
fremitus1344023fremitus
frets85523403fr_et_s
frites94922483fr_ites
friths124313583fr_iths
frits86129103fr_it_s
fritts94613193fr_itts
frocks154111213froc_ks
frontes104214163frontes
fronts94415793front_s
frosts94214623frost_s
froths125411443fr_oths
fructose1343663fructose
fructuous1442393fructuous
fruits94512493fruit_s
frustum1243953frustum
frustums1342993frustums
fucous11399863f_ucous
fucus105515893f_uc_us
furcates1339883furcates
fuscous1256673fuscous
graces94523493grac_es
gracious1138593gracious
gradus84411223gra_dus
grafts105013253graft_s
grampus12356313grampus
grants73722473grant_s
grates75429893gra_tes
gratis74819243gra_tis
hiatus938223hia_tus
ictus7249703__ictus
infracts1346623infract_s
krafts13438853kraft_s
kraits104912203krait_s
krauts10418513kraut_s
meatus85112923mea_tus
oraches124216473oraches
oracles93212423oracles
orates64328613ora_tes
pacts95125803_pact_s
practic13312243practic
practise12310143practise
prahus11458243pra_hus
prates84633163pra_tes
prats76333393pra_t_s
praus74621753pra__us
preacts113211363preact_s
precuts111710473precuts
racers84725433_racers
races74943243_rac_es
rachis114017653_rachis
racks115028853_rac_ks
racons84319343_racons
radius73914873_radius
rafts87820633_raft_s
raitas64417673_raitas
rakus94413673_ra_kus
ramous8417113_ramous
ramus76418283_ra_mus
rants55935343_rant_s
rates55352013_ra_tes
ratos55528763_ra_tos
rats46260373_ra_t_s
raucous938303_raucous
reacts83616603react_s
rectos85718783_rectos
rectum103411283_rectum
rectums11338523_rectums
recuts83817373_recuts
refracts13137383refract_s
ruckus12407793_ruckus
sarcous9312933sarcous
stactes91914633stactes
status65515213sta_tus
stratus73011733stra_tus
tacts76524123_tact_s
tracers94917843tracers
traces85329933trac_es
tracks124818843trac_ks
tract75635713tract__
tractor9311333tractor
tractors10312563tractors
tragus749233tra_gus
traits65121983trait_s
turacous1047143turacous
uracils939373uracils
uraeus638793ura_eus
uranous7310733uranous
urates65027763ura_tes
vatus86114643_va_tus
wracks154711113wrac_ks
wraiths1355033wraiths
wraths123810083wra_ths

Search took 8 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.406440125.6
2DLD Change Limit1340272147.45317983.0
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.93522519.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.