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

46 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
singularity155276(None) 
angularity1454252_angularity
insularity1354522_insularity
singularize2152512singularize
singularly1453232singular_ly
binocularity1962483binocularity
circularity1855563circularity
regularity1454043_regularity
secularity1545773s_ecularity
similarity1554723si_milarity
singular9327563singular___
singularities1452663singularities
singularized2361863singularized
singularizes2252323singularizes
singulars10305633singular__s
specularity1853963specularity
triangularity1761763triangularity
angularly1344164_angular_ly
avuncularity2061724avuncularity
bipolarity1753034bi_polarity
cellularity1652564cellularity
cingular11256974cingular___
cingulate12238604cingula__te
granularity1553314granularity
hilarity1447174hi___larity
inhumanity18133144_inhumanity
insularism1253724_insularism
insularly1245324_insular_ly
irregularity1691984irregularity
jocularity2253684_jocularity
linearity1246114lin__earity
lingular9407504lingular___
lingulate10368194lingula__te
modularity1663324_modularity
muscularity1853304muscularity
oracularity1653404oracularity
popularity1754684_popularity
sanguinarily1661614sanguinarily
sanguinity1453054sangu_inity
sensuality1344434sensu_ality
sincerity1445144sin__cerity
singularizing2481964singularizing
sinuosity1243854sin_u_osity
unclarity1445364_un_clarity
vascularity1983574vascularity
vesicularity2062834vesi_cularity

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 Filter1786911488190.420425454.8
2DLD Change Limit148819468.59617312.6
3Display Results46460.0133538.5
 (SQL Overall)178691469.02919790.8
 
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.