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

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
humerus1236921humerus
humdrum1543522humdrum
humeral1238572humeral
humeri1138522humer_i
demerit10314993demerit
fumer105918233fumer__
fumers113613383fumer_s
fumet105630223fume__t
haleru94212083haleru_
hideout1179793hideout
homer105828453homer__
homered133212713homered
homeric14312213homeric
homers114821983homer_s
hugeous1137133hugeous
huger94914873huger__
hugest10311763huge_st
humbug1434803hum_bug
humdrums1642703humdrums
humerals1347183humerals
hummer133615273hummer__
hummers143813063hummer_s
hummus1336243hum_mus
humor101110513humor__
humoral1237983humoral
humored1336723humored
humorful1642273humorful
humorist1348783humorist
humorous1346453humorous
humors11129633humor_s
humour11116753hum_our
humours1286443humours
humper134115883humper__
humpers142713523humper_s
humus106215073hum__us
hurst85527193hu__rst
hurt77142573hu__r_t
hutment1239173hutme_nt
merit7339183__merit
numeral939083numeral
numerate101610393numerate
numeric1158193numeric
numerous1047853numerous
thumbnut15122743thumbnut
timeout948593timeout
umlaut838033_umlaut
uterus639203_uterus

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit134027476.36021073.4
3Display Results47470.0133615.4
 (SQL Overall)178691476.79626293.6
 
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.