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

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

57 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
humanity164631(None) 
humanely1643812humanely
humanise1348512humanise
humanism1548092humanism
humanist13410492humanist
humanists1446842humanists
humanize2247782humanize
humanly1545682human_ly
humidity1745232humidity
humility1646102humility
inhumanity18133152inhumanity
amanita9310453_amanita
amenity1238333_amenity
aminity12310513_aminity
audacity1444823audacity
aurality1139223aurality
duality1147973du_ality
feminity1647553feminity
fugacity1743323fugacity
hematite131612153hematite
hilarity1447173hilarity
human102716033human___
humane112812173human__e
humaner12257663human_er
humanest1348123humanest
humanised1545953humanised
humanises1448313humanises
humanisms1646683humanisms
humanistic1744393humanistic
humanities1547063humanities
humanized2446533humanized
humanizer2345723humanizer
humanizes2347533humanizes
humankind1942343humankind
humanlike1843283humanlike
humanoid1445713humanoid
humanoids1543983humanoids
humans112312433human__s
humate113214443huma__te
humidify2042723humidify
immunity1544733immunity
inanity1039503_inanity
insanity1147343insanity
manito8518693__manito
manitu8315823__manitu
mundanity1543523mundanity
quality1938563qu_ality
quantity2044733qu_antity
rurality1137403rurality
sanity9316203__sanity
suavity1336323su_avity
tumidity1444963tumidity
umangite1144823_umangite
unity84918493_u__nity
uranite72515693_uranite
urbanity13105303urbanity
vanity12311933__vanity

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit146162576.81321453.4
3Display Results57570.0301900.0
 (SQL Overall)178691577.27924548.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.