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

285 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
fracti113996(None) 
bract96332722bract_
bracts105617772bracts
cacti9318632_cacti
fact97142542f_act_
facts107021892f_acts
farci105919312farc_i
fracas11311992fracas
fractal1237622fractal
fracted1339372fracted
fraction1359482fraction
fractur12135562fractur
fractus12146592fractus
frantic12310362frantic
frat75648542fra_t_
frats86829672fra_ts
practic13312242practic
recti73619622_recti
tract75635712tract_
tracts85019072tracts
abaci94718843abac_i
act59557843__act_
acta69524803__acta
actin74922553__actin
acts66929863__acts
anti45536363__anti
apractic1448303apractic
arctic10313513ar_ctic
atactic11410083atactic
bhakti1544323bhakti
brace95629273brac_e
braced115420603braced
bracer104620583bracer
braces108427773braces
brach126123303brac_h
brachia141910423brachia
brachs134415753brachs
bracted12410933bracted
brant74742173brant_
brants85723053brants
brat66055543bra_t_
brats75336013bra_ts
bratty1159683bratty
bravi104715753bra_vi
coact96130573coact_
coacts105314323coacts
coati75624633coa_ti
crack134120533crac_k
cracks144817003cracks
cracky175010223cracky
craft105327663craft_
crafts115312743crafts
crafty14478913crafty
cratch134110793cratch
crate76537403cra_te
croci95818133croc_i
drachm1436493drachm
draft95526683draft_
drafts105012533drafts
drafty13638933drafty
drastic10310863drastic
drat56247833dra_t_
drats66628373dra_ts
enact73525363enact_
enacts84012973enacts
epact94921533epact_
epacts105010393epacts
erect74129333erect_
erects84116183erects
eruct74022353eruct_
eructs83610793eructs
exact143516933exact_
exacta15337393exacta
exacts15359613exacts
face96140123f_ac_e
faced117727653f_aced
facer105525053f_acer
faces106439433f_aces
facet106038523f_acet
facete115014833f_acete
facets116316653f_acets
facia103218463f_acia
faction122613333f_action
factoid1338693f_actoid
factor11911453f_actor
faith115620853f_aith
farce104925323farc_e
farced125216533farced
farcer115016083farcer
farces115223323farces
farcie114816473farcie
farcy135217093farc_y
fart76860563f_art_
farts88336843f_arts
fast77052313f_ast_
fasts86429683f_asts
fat68178083f_a_t_
fate75444283f_a_te
fats76252503f_a_ts
fatty115117413f_atty
fealty122910223fealty
feast85932723feast_
feasts95116093feasts
feat76458223fea_t_
feats86432753fea_ts
feracity1646733feracity
fiacre1137623fiacre
fiaschi1542793fiaschi
fiat76646643fia_t_
fiats85324483fia_ts
flaccid1544393flaccid
flack144519413flac_k
flacks154114533flacks
flacon1138633flacon
flat77147823fla_t_
flats86429743fla_ts
flauta937823flauta
flocci1335023flocci
foci94521013f_oc_i
fractals1346133fractals
fractions1449103fractions
fractious1456143fractious
fracture13147123fracture
fracturs13146303fracturs
frae75330473fra__e
fraena938063fraena
frag85126273fra__g
frags96322163fra_gs
frail85220213fra_il
frails93716473frails
frailty1335663frailty
fraise94214913fraise
fraktur14153033fraktur
frame105821803fra_me
framed125116523framed
framer114817443framer
frames115119863frames
franc104615413fra_nc
francs114112193francs
frank124417513fra_nk
franks134912733franks
frap95925813fra__p
frappe13286953frappe
fraps105620553fra_ps
frass85321123fra_ss
frater94520593frater
fraud939863fra_ud
frauds1036753frauds
fray105428903fra__y
frayed135012163frayed
frays116920103fra_ys
frazil1847223frazil
fret75845043fr_et_
frets85523403fr_ets
fretty1249223fretty
friction1347913friction
frit77044473fr_it_
frith115922033fr_ith
frits86129103fr_its
fritt86129413fr_itt
fritts94613193fritts
fritz176020773fr_itz
frock145314653froc_k
frocks154111213frocks
front85029223front_
fronts94415793fronts
frost84727833frost_
frosts94214623frosts
frosty124710633frosty
froth115919283fr_oth
fructify1942353fructify
fruit85122223fruit_
fruits94512493fruits
fruity12429693fruity
frusta937453frusta
fuci95720313f_uc_i
furcate12310453furcate
grace85124543grac_e
graced105217903graced
graces94523493graces
graft95327203graft_
grafts105013253grafts
grant64840023grant_
grants73722473grants
grat55651283gra_t_
grate64932883gra_te
gratin74520583gra_tin
gratis74819243gra_tis
infract12610003infract_
infracts1346623infracts
irate55627983ira_te
kraft125721013kraft_
krafts13438853krafts
krait94726773krait_
kraits104912203kraits
kraut95221403kraut_
krauts10418513krauts
lactic10713493_lactic
lati46438273_la_ti
orach105219233orac_h
orache114013593orache
oracle84313293oracle
orate55133303ora_te
orectic1138823orectic
pact86648723_pact_
pacts95125803_pacts
practice1438733practice
practise12310143practise
prat65952043pra_t_
prate75135983pra_te
prats76333393pra_ts
preact103220393preact_
preacts113211363preacts
rabbi93113183_rabbi
race66746263_rac_e
raced87635313_raced
racer75233023_racer
races74943243_races
rachis114017653_rachis
rack106234883_rac_k
racks115028853_racks
racon75422143_racon
racy95825683_rac_y
radii64016413_radii
raft76245913_raft_
rafts87820633_rafts
ragi56032283_ra_gi
rai37658223_ra__i
raita54623073_raita
raki87127833_ra_ki
rami66034093_ra_mi
ramtil8311023_ramtil
rani46640103_ra_ni
rant45864673_rant_
rants55935343_rants
rapt67245313_rapt_
rat37892743_ra_t_
ratch104221363_ratch
rate45458763_ra_te
rath76037663_ra_th
ratio55227583_ra_tio
rato45436973_ra_to
rats46260373_ra_ts
ratty84819593_ratty
react74634333react_
reacts83616603reacts
recit75235103_recit
recta74220263_recta
recto74520803_recto
refract121311603refract_
refracts13137383refracts
roti46332923_r_oti
sati45539323_sa_ti
shanti94014073shanti
smalti84111173smalti
stacte82113913stacte
strati63518893stra_ti
tacit76333673_tacit
tact67349033_tact_
tactic10612753_tactic
tacts76524123_tacts
trace75829613trac_e
traced94821583traced
tracer84820233tracer
traces85329933traces
track114823013trac_k
tracks124818843tracks
tractile10311073tractile
traction10412683traction
tractive13310043tractive
tractor9311333tractor
tragi64717173tra_gi
trait56940843trait_
traits65121983traits
trapt76433393trapt_
uracil8311543uracil
uraei53016083ura_ei
urari54619963ura_ri
urate55432163ura_te
uratic83016353ura_tic
wrack145413883wrac_k
wracks154711113wracks
wraith1258603wraith
wrapt105123183wrapt_
wrath115715873wra_th

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162855.69019809.5
3Display Results2852850.0933064.5
 (SQL Overall)1786912855.92330169.0
 
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.