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

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
nonpayments185415(None) 
nonpayment1755071nonpayment_
copayments1944312co_payments
nonparents1246072nonpa_rents
copayment1845893co_payment_
nonparent1148663nonpa_rent_
payments1536943___payments
prepayments2053333prepayments
repayments1744903_repayments
compartments2094334compartments
complements1948184complements
compliments1946584compliments
concealments1854074concealments
condiments1548194con_diments
conferments1848324conferments
congealments1753294congealments
containments1655784containments
coparents1347974co_pa_rents
couplements1756194couplements
embayments1944514_embayments
enjoyments2254074_enjoyments
fundaments1653864funda_ments
godparents1451974godpa_rents
inpatients1244294_inpatients
lineaments1245504linea_ments
monuments1397634mon__uments
nonarguments15123504nonarguments
nonemployments2372504nonemployments
nonevents1247484non__events
nonfarmers1544174nonfarme_rs
nonmarkets1653034nonmarke_ts
nonpagans1243834nonpa_gan_s
nonpapists1443954nonpa_pists
nonpareils1253004nonpa_reils
nonpasts1046554nonpa___sts
nonpaying1545714nonpay_in_g
nonplayers1543944nonplay_e_rs
nonstudents1252914nonstudents
nontreatments1563294nontreatments
ornaments1146634_orna_ments
orpiments1346004_orp_iments
overpayments2253494overpayments
payment14310704___payment_
prepayment1944604prepayment_
repayment1646344_repayment_
underpayments2162504underpayments
wonderments1754514wonderments

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 Filter1786911488190.423422437.4
2DLD Change Limit148819478.31317902.0
3Display Results47470.0331424.2
 (SQL Overall)178691478.76920377.6
 
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.