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

139 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
practise1231014(None) 
practice1438731practice
practised1446101practised
practises1349621practises
practic13312252practi_c
practiced1655112practiced
practicer1544592practicer
practices1557992practices
praise84419412pra__ise
precise113518172prec_ise
proactive1648362proactive
tractile10311072tractile
tractive13310042tractive
active11313743__active
apractic1448303apracti_c
baptise1139553_baptise
brackish1987613brackish
bracts105617773bract_s_
braise84318753bra__ise
brattice1245693brattice
brattish1346973brattish
chastise1348173chastise
coactive1598623coactive
crabwise1543613crabwise
dramatise1247323dramatise
enactive1338513enactive
erectile1039513erectile
erective13311833erective
fracti1139963fracti__
fraction1359483fraction
fracture13147143fracture
fractus12146593fractus_
fraise94214913fra__ise
franchise1746003franchise
fructose1343663fructose
gracile102512603grac_ile
gratine84719193gra_tine
gratis74819243gra_tis_
inactive1348203inactive
lactase937963_lactase
lactose969493_lactose
orective1339353orective
pachisi14329523p_achisi
paction112713963p_action
pacts95125803p_act_s_
paise75028333p_a__ise
pantie84326473p_anti_e
panties94230933p_anties
pantile93918483p_antile
paracrine1348733paracrine
paradise112113873paradise
parasitise1277403parasitise
parchisi15368933parchisi
parclose1247243parclose
parities10522973parities
parties93230863p_arties
partite9317133p_artite
parvise124211693p_arvise
pastie85525523p_asti_e
pasties94529813p_asties
pastime114611973p_astime
pastis84924323p_astis_
pastises103616053p_astises
patine85328123p_a_tine
pattie84020963p_atti_e
patties93425143p_atties
pavise114714803p_a_vise
peacetime1544473peacetime
pectase112410363p_ectase
pectize20259913p_ectize
piracies12312643pirac_ies
placative1646223placative
platies93722543pla_ties
playtime1544793playtime
poetise9314043p_oetise
practical1548843practical
practicers1663593practicers
practicum17133773practicum
practising1586363practising
praecipe1444633praecipe
prairie938333prairi_e
prairies10411453prairies
praised104214813pra__ised
praiser93413943pra__iser
praises94121103pra__ises
praline93019743pra_line
prankish1737023prankish
prase76128753pra___se
prate75135983pra_t__e
prates84633163pra_tes_
prating103424453pra_ting
pratique19134283pra_tique
prats76333393pra_t_s_
prattle9208833pra_ttle
prattles10189403prattles
praxis154012253pra_xis_
praxises1739063pra_xises
preaccuse1543543preaccuse
preacting142412533preacting
preacts113211363preact_s_
precative16312573precative
prechose15129773prechose
precipe133012123prec_ipe
precis103416703prec_is_
precised133213413prec_ised
preciser123411663prec_iser
precises123218333prec_ises
premise113818553pr_emise
prentice121012353prentice
prestige11310733prestige
pretties10615133pretties
previse123713793pr_evise
prise74632613pr___ise
pristine10313503pristine
privatise14167763privatise
proaction13410103proaction
procaine12312273procaine
proclises1339543proclises
promise113415843pr_omise
prostie91617743prosti_e
prosties101421193prosties
protist9320223pr_otist
rachis114017653_rachis_
rachises131412413_rachises
racism103214193_rac_ism
racist82822793_rac_ist
ragtime1036163_ragtime
raise54828053_ra__ise
ratine65131823_ra_tine
ratite65022423_ra_tite
rattish10510823_rattish
reactive13310473reactive
tactile9310613_tactile
tractate10411003tractate
traction10412683traction
tracts85019073tract_s_
travoise1145603travoise
treatise8311103treatise
upraise9158603upra__ise

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621397.00020880.3
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.48623870.0
 
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.