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

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

47 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
nonpracticing206175(None) 
nonpractical1854233nonpractic_al
practicing1775583___practicing
contracting16610474contract__ing
nonacting1238784non__act__ing
nonproducing1852524nonpr_oducing
practising1586364___practising
apprenticing1962305_apprenticing
bratticing1543925___bratticing
compacting19177095comp_act__ing
concretizing2654305concr_etizing
contacting15610075con_tact__ing
contractility2074075contractility
contraction15411245contracti_on_
contractions16410405contracti_ons
contradicting1954075contra_dicting
contrasting1459355contrast__ing
infracting1647355_infract__ing
morticing1448015mo__r__ticing
nonaction1149445non__acti_on_
nonactions1248375non__acti_ons
nonbreathing1852105nonbreat_hing
nonfattening1661865non_fattening
nonfunctioning207925nonfunctioning
nonirritating1472515nonirritating
nonoperating1555415nonopera_t__ing
nonparticipant20131615nonp_articipant
nonpartisan1353005nonp_artisan_
nonpaying1545715nonp_a___ying
nonplastic1447005nonplastic___
nonplastics1554645nonplastic__s
nonplaying1644445nonpla___ying
nonpolitician1762605nonpolitician
nonpoliticians1872115nonpoliticians
nonprossing1454495nonpr__ossing
nonprotein1254825nonpr_ot_ein_
nonrecurring15152275non_recurring
nonreducing1553175non_r_educing
nonrioting1146755non_riot__ing
nonrotating1246305non_r_otating
nonteaching1753585nonteac__hing
noticing1139455no_____ticing
ostracising1443875_ostrac_ising
ostracizing2344565_ostrac_izing
overacting16310915_overact__ing
prenticing1547885___prenticing
unpractical1753765_unpractic_al

Search took 9 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 Filter1786911247900.406440125.6
2DLD Change Limit124790478.17315268.6
3Display Results47470.0162937.5
 (SQL Overall)178691478.59520790.1
 
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.