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

68 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
humorist134878(None) 
humorists1445781humorists
amorist9317642_amorist
humanist13410492humanist
humoring1456852humoring
humoristic1754382humoristic
humors11129632humor_s_
sumoist9311612sumo_ist
amorists10411323_amorists
aorist64827873__aorist
aphorist13412503aphorist
arborist10411613arborist
aurist65027253au__rist
camorrist1345963camorrist
colorist102818993colorist
demonist11413463demonist
demotist11311843demotist
eulogist949043eulogist
florist10314243_florist
futurist1148283futurist
harmonist141310663harmonist
hedonist1249553hedonist
hoist86433213h__o_ist
holist94723213h__olist
homilist13410033homilist
hornist102314823h__ornist
horst85833513h__or_st
hubris11218973hu_bris_
humanest1348123humanest
humanise1348513humanise
humanism1548093humanism
humanists1446843humanists
humblest15288283humblest
humeri1138523humeri__
humerus1236913humerus_
humor101110513humor___
humoral1237973humor_al
humored1336723humor_ed
humorful1642263humorful
humorless1442963humorless
humorous1346443humorous
humouring1544553humouring
humours1286413humours_
humpiest1538963humpiest
hungriest1344543hungriest
hurst85527193hu__r_st
hymnist1546633hym_nist
hymnodist1844203hymnodist
judoist1545633judo_ist
jurist134616393ju__rist
luminist10410563luminist
memoirist1345983memoirist
memorise121411433memorise
moist76033583__mo_ist
monist84324983__monist
motorist10314413motorist
purist85525053pu__rist
querist16311133qu_erist
rigorist949123rigorist
rumoring1136983rumoring
rumors81110393rumor_s_
simonist10410723simonist
summarist13116763summarist
sumoists1046733sumo_ists
tenorist8413023tenorist
theorist1149553theorist
tumors8810603tumor_s_
utopist938693_utopist

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.1701051123.5
2DLD Change Limit146162687.31319986.6
3Display Results68680.0332060.6
 (SQL Overall)178691687.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.