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

203 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
practic1331224(None) 
apractic1448301apractic
practice1438731practice
arctic10313512ar_ctic
atactic11410082atactic
drastic10310872drastic
fracti1139962fracti_
frantic12310362frantic
lactic10713492_lactic
orectic1138822orectic
paretic113016672paretic
parotic112518042parotic
pectic122913872p_ectic
phatic133014412pha_tic
piratic11314292pira_tic
plastic112815062plastic
practical1548842practical
practiced1655112practiced
practicer1544592practicer
practices1557992practices
practicum17133772practicum
practise12310142practise
tactic10612752_tactic
uratic83016352ura_tic
acetic10314503__acetic
acmic11312333__acmic
actin74922553__actin
antic75728863__antic
aplastic1249243aplastic
apraxic1846293apra_xic
aprotic112715243apr_otic
arabic10312733ara_bic
arctics1138953ar_ctics
argotic10310283argotic
ataractic1346233ataractic
attic75618353__attic
barytic1437823barytic
boracic1338723borac_ic
brachia141910423brachia
bract96332723bract__
bracted12410933bracted
bracts105617773bract_s
brattice1245693brattice
cacti9318643_cacti_
cantic103920543_cantic
chaotic14310043chaotic
clastic113013963clastic
cretic102816283cr_etic
critic103616813cr_itic
cryptic1646153cryptic
deictic1237703deictic
didactic1445183didactic
draconic1346193draconic
dramatic1369423dramatic
elastic93013393elastic
enatic8317563ena_tic
ergastic11106623ergastic
ergotic1049723ergotic
eristic9814093eristic
erotic82620273er_otic
erratic9311113erratic
fractal1237623fractal
fracted1339373fracted
fraction1359483fraction
fractur12135563fractur
fractus12146593fractus
galactic13106533galactic
granitic1168623granitic
graphic1537353graphic
gratin74520583gra_tin
gratis74819243gra_tis
haptic13511893_haptic
hectic132311523_hectic
ictic9311803__ictic
iritic83213823ir_itic
karstic1357983karstic
mantic104120903_mantic
mastic103119173_mastic
narcotic1277913narcotic
nastic82915973_nastic
operatic1249933opera_tic
orgastic11116213orgastic
pacific1646913p_acific
pact86648723p_act__
paction112713963p_action
pacts95125803p_act_s
panic93923903p_a_nic
pantie84326473p_antie
parachutic1954293parachutic
paralytic1647973paralytic
paranoic1249833paranoic
parasitic1349523parasitic
paratactic1684633paratactic
paretics122312443paretics
parodic122311723parodic
parotid102915513parotid
pastie85525523p_astie
pastil85018323p_astil
pastis84924323p_astis
patin76832853p_a_tin
patio74426353p_a_tio
pattie84020963p_attie
pectin102615533p_ectin
pedantic1346583pedantic
pelitic111814653pelitic
peptic122113153p_eptic
peracid12312993perac_id
periotic12313443periotic
perlitic12310583perlitic
phallic1447293phallic
phasic133612053pha_sic
photic133316443p_hotic
phratric1545943phratric
phreatic1548343phreatic
pianic103714123pia_nic
picnic123410263p_icnic
picric12309923p_icric
placid114012543plac_id
placoid1239773placoid
plasmic13249113plasmic
plastics122412333plastics
plastid102112523plastid
poditic122611583poditic
poetic10416843p_oetic
politic112918713politic
practicals1645543practicals
practicers1663593practicers
practicing1775583practicing
practicums18132753practicums
practised1446103practised
practises1349623practises
praetor938973praetor
pragmatic1647633pragmatic
prairie938333prairie
prat65952043pra_t__
prate75135983pra_t_e
prated94924923pra_ted
prater84825353pra_ter
prates84633163pra_tes
prating103424453pra_ting
prats76333393pra_t_s
prattle9208833prattle
praxis154012253pra_xis
preact103220393preact__
preacted132710943preacted
preacting142412533preacting
preacts113211363preact_s
precis103416703prec_is
prelatic12311283prelatic
prentice121012353prentice
priapic1346023priapic
proaction13410103proaction
proactive1648363proactive
proclitic1548113proclitic
proctor11310433proctor
prolactin1347773prolactin
prosaic11311163prosaic
prostie91617743prostie
protatic12314743protatic
pruritic1267403pruritic
prussic1144743prussic
psalmic1345333psalmic
psoatic1139303psoatic
psychic1944833psychic
ptotic102713373p_totic
puranic11410483pura_nic
puristic1239383puristic
pyaemic1645873pyaemic
pyretic143210783pyretic
pyritic143311313pyritic
quantic18279063quantic
quartic18258473quartic
rabic93817403_ra_bic
racemic1336983_racemic
rachis114017653_rachis
rachitic1547593_rachitic
ramtil8311023_ramtil
ratio55227583_ra_tio
recti73619623_recti_
rhotic112711233_rhotic
rustic8712673_rustic
smectic1336613smectic
spastic11310383spastic
static83118683sta_tic
tactics1149323_tactics
trachytic1944183trachytic
tract75635713tract__
tractile10311073tractile
traction10412683traction
tractive13310043tractive
tractor9311333tractor
tracts85019073tract_s
traffic1544733traffic
tragic93811543tra_gic
tryptic1446003tryptic
uracil8311543urac_il
uraemic1156543uraemic
uralitic10158453uralitic
uranic82315183ura_nic
uranitic10148683uranitic
uretic82914353ur_etic
vatic10316423_va_tic
viatic11311453via_tic

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.390458182.1
2DLD Change Limit1340272036.97019229.1
3Display Results2032030.0802537.5
 (SQL Overall)1786912037.44024017.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.