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

31 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
arbitrarinesses176142(None) 
arbitrariness1571892arbitrarine_s_s
abstractnesses1862294a_bstractnesses
arbitresses1343344arbit__r__esses
contrarinesses1674244_contrarinesses
literarinesses1483354__literarinesses
ordinarinesses1552354ordi_narinesses
solitarinesses1452974solit_arinesses
abstrusenesses1552565a_bstrusenesses
adversarinesses1971505adversarinesses
airinesses102613615a__i___rinesses
ambitiousnesses1964935ambitiousnesses
artinesses10815215ar__t___inesses
artsinesses1138715ar__t__sinesses
bitchinesses1943525__bit_chinesses
bitternesses1444535__bitter_nesses
bittinesses13148265__bit__tinesses
bizarrenesses2452005__bizarrenesses
blearinesses1446545__b_learinesses
blurrinesses1484115__blur_rinesses
drearinesses1347445dr___earinesses
fruitinesses1546445fruit___inesses
grittinesses1345845gr_it__tinesses
habitualnesses1962215habitua_lnesses
jitterinesses2083315__jitterinesses
ritzinesses2096745_r_it__zinesses
salutarinesses1462775salut_arinesses
tarrinesses11129085____tarrinesses
tearinesses11311695____tearinesses
temporarinesses1961985temporarinesses
visionarinesses1861665visionarinesses

Search took 6 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 Filter178691658740.406440125.6
2DLD Change Limit65874314.90613427.2
3Display Results31310.0161937.5
 (SQL Overall)178691315.32833538.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.