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 “practices” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
practices155799(None) 
practice1438731practice_
practiced1655111practiced
practicer1544591practicer
practicers1663591practicers
practises1349621practises
brattices1345552brattices
practic13312242practic__
practical1548842practical
practicals1645542practicals
practicum17133772practicum
practicums18132752practicums
practise12310142practise_
practised1446102practised
prentices131111902prentices
actives12311523__actives
apractic1448303apractic__
arctics1138953ar_ctic_s
brattice1245693brattice_
bratticed1443283bratticed
fractions1449103fractions
fractious1456143fractious
fractures14147233fractures
graciles112511613grac_iles
latices9313763_la_tices
lattices1038383_lattices
malpractices2061603malpractices
oratrices1145833oratrices
pactions122613503p_actions
panties94230933p_anti_es
pantiles103617153p_antiles
paretics122312443paretic_s
parities10522973pariti_es
particles1339803p_articles
parties93230863p_arti_es
pastiches1637453p_astiches
pasties94529813p_asti_es
pastimes123611903p_astimes
pastises103616053p_astises
patines95225763p_a_tines
patties93425143p_atti_es
peacetimes1643873peacetimes
pectines121914683p_ectines
pectizes21229793p_ectizes
piracies12312643pirac_i_es
plaices11411143pla__ices
plastics122412333plastic_s
platies93722543pla_ti_es
playtimes1644413playtimes
poultices1345673poultices
practicing1775583practicing
praecipes1544853praecipes
prairies10411453prairi_es
praises94121103pra__ises
pralines102217723pra_lines
prances113618773pra__nces
prates84633163pra_t__es
pratiques20114213pra_tiques
prattles10189403pra_ttles
praxises1739063pra_xises
precipes143212213prec_ipes
precipices1845513precipices
precises123218333prec_ises
prentice121012353prentice_
prenticed14118063prenticed
preprices1569263preprices
preslices1338213preslices
prestiges12310593prestiges
pretties10615133pretti_es
prices104524543pr___ices
proactions1449343proactions
proactive1648363proactive_
procaines13311523procaines
proclises1339543proclises
proctitis1348363proctitis
prosties101421193prosti_es
rachides141511223_rachides
rachises131412413_rachises
radices102314263_ra_dices
ragtimes1135823_ragtimes
ratines75328583_ra_tines
ratites74920683_ra_tites
rectrices1338873_rectrices
statices102712343sta_tices
tactics1149323_tactic_s
tractates1159763tractates
tractile10311073tractile_
tractions11511623tractions
tractive13310043tractive_

Search took 10 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 Filter1786911486410.420425454.8
2DLD Change Limit148641898.56317358.5
3Display Results89890.173514.5
 (SQL Overall)178691899.15619516.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.