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

51 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
nonperforming216202(None) 
nondeforming1992522nonde_forming
nonconforming21103473nonconforming
nonperformance23231963nonperformance
nonperformer19162343nonperform_er
nonperformers20152173nonperformers
outperforming2161273outperforming
performing1844943___performing
conforming1847374con___forming
nonperformances24221804nonperformances
nonprossing1454494nonp_r_ossing
preforming1846234___preforming
conferring1648745confer__r_ing
confirming1845905con___firming
deforming1636705___de_forming
informing1537025_in___forming
interfering1558925_interfer_ing
interfolding1754585_interfolding
interworking2054525_interworking
nonbearing1346455nonbe__ar_ing
nonconformism22103125nonconformism
nonconformist20103675nonconformist
nonconformity2363075nonconformity
noncorroding1652335noncorro_ding
nonearning1145185non_e__arning
nongrowing1543765non_gr_o_wing
nonoperating1555415nonoper__ating
nonperson1165265nonperso___n_
nonpersons1285505nonperso___ns
nonproducing1852525nonp_roducing
nonprotein1254825nonp_r_otein_
nonrecurring15152275nonre_curring
nonrioting1146755non__rio_ting
nonsporting1444825non__sporting
nonuniformity2171465nonuniformity
nonworking1844215non___working
nonyellowing195975nonyello_wing
overarming1639235_o_ver_arming
overcoming1848735_o_verco_ming
overinforming2252855_o_verinforming
overlording1647465_o_verlording
overwarming2046305_o_verwarming
overworking2246035_o_verworking
perforating1747025___perforating
perfuming1784055___perf_uming
postforming1953265po__stforming
reforming1538565___re_forming
slipforming1951575slip__forming
underworking2153455_underworking
uniforming1643795_un__iforming
unperformed1972495_unperform_ed

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.390458182.1
2DLD Change Limit124790518.45314762.8
3Display Results51510.0301700.0
 (SQL Overall)178691518.87320138.7
 
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.