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

105 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
practice143873(None) 
practic13312251practic_
practiced1655111practiced
practicer1544591practicer
practices1557991practices
practise12310141practise
apractic1448302apractic_
brattice1245692brattice
practical1548842practical
practicers1663592practicers
practicum17133772practicum
practised1446102practised
practises1349622practises
prentice121012352prentice
proactive1648362proactive
tractile10311072tractile
tractive13310042tractive
active11313743__active
arctic10313513ar_ctic_
arctics1138953ar_ctics
atactic11410083atactic_
bratticed1443283bratticed
brattices1345553brattices
coactive1598623coactive
drastic10310883drastic_
enactive1338513enactive
erectile1039513erectile
erective13311833erective
fracti1139963fracti__
fraction1359483fraction
fracture13147143fracture
frantic12310373frantic_
gracile102512603grac_ile
gratine84719193gra_tine
inactive1348203inactive
lactic10713493_lactic_
lattice938433_lattice
malpractice1952153malpractice
orectic1138823orectic_
orective1339353orective
paction112713963p_action
pantie84326473p_anti_e
pantile93918483p_antile
paracrine1348733paracrine
paretic113016673paretic_
paretics122312443paretics
parotic112518043parotic_
particle1239533p_article
partite9317133p_artite
pastiche1546933p_astiche
pastie85525523p_asti_e
pastime114611973p_astime
patine85328123p_a_tine
pattie84020963p_atti_e
peacetime1544473peacetime
pectic122913873p_ectic_
pectize20259913p_ectize
phatic133014413pha_tic_
piratic11314293pira_tic_
placative1646223placative
plaice10311553pla__ice
plastic112815063plastic_
plastics122412333plastics
playtime1544793playtime
poultice1246063poultice
practicable1953833practicable
practicals1645543practicals
practicing1775583practicing
practicums18132753practicums
praecipe1444633praecipe
prairie938333prairi_e
praise84419413pra__ise
praline93019743pra_line
prance104318573pra__nce
prate75135983pra_t__e
prating103424453pra_ting
pratique19134283pra_tique
prattle9208833pra_ttle
preacting142412533preacting
precative16312573precative
precipe133012123prec_ipe
precipice1745953precipice
precise113518173prec_ise
prenticed14118063prenticed
prentices131111903prentices
preprice1488873preprice
preslice1258623preslice
prestige11310733prestige
price93725413pr___ice
pristine10313503pristine
proaction13410103proaction
procaine12312273procaine
prochoice1845153prochoice
prostie91617743prosti_e
ragtime1036163_ragtime
ratine65131823_ra_tine
ratite65022423_ra_tite
reactive13310473reactive
statice92614033sta_tice
tactic10612753_tactic_
tactics1149323_tactics
tactile9310613_tactile
tractate10411003tractate
traction10412683traction
uratic83016363ura_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 Filter1786911461620.406440125.6
2DLD Change Limit1461621057.00020880.3
3Display Results1051050.0303500.0
 (SQL Overall)1786911057.43624030.5
 
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.