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

78 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
disgusted124610(None) 
degusted1135732d_egusted
digested11208162di_gested
discussed13256752discussed
disguised1245962disguised
disgust937622disgust__
disgustedly1752072disgustedly
disgusts1045642disgust_s
dismasted1346822dismasted
disputed1238332dispu_ted
disrupted1345962disrupted
distasted1137952distasted
distrusted1246262distrusted
disused93211012dis_us_ed
desisted1039783des_isted
diffused1643473diffus_ed
digester10258423di_gester
dighted132511493di_g_hted
diluted9248933di_lu_ted
dinguses1037633dingus_es
disabused1344883disabus_ed
disaster949943dis_aster
disbudded1543283disbudded
disbursed1365753disbursed
discanted1339333discanted
discased122510843discas_ed
discepted1547523discepted
discounted1447843discounted
discuses113112853discus_es
discusser12246173discusser
discusses12268233discusses
diseased103011703diseas_ed
diseuse83110713diseus_e_
diseuses93112753diseus_es
disgorged1345253disgorged
disgraced1446733disgraced
disgruntled1451913disgruntled
disguise1046823disguise_
disguiser1145083disguiser
disguises1146863disguises
disgustful1552003disgustful
disgusting1345963disgusting
disjected2086353disjected
dismissed1344603dismissed
dismounted1445413dismounted
disparted1338853disparted
disported13310303disported
disposed12310923dispos_ed
dispute1039083dispu_te_
disputer1137973dispu_ter
disputes1139653dispu_tes
disquieted2143983disquieted
disrated10915573dis_rated
disrooted1147623disrooted
disrupter1244723disrupter
disseated11711073disseated
dissected13108653dissected
dissed85220173dis__s_ed
dissented1199713dissented
disserted11109803disserted
dissuaded1265423dissuaded
distaste939943distaste_
distastes1039623distastes
distorted1139363distorted
disturbed13195573disturbed
disunited1177253disunited
disuse74012833dis_us_e_
disuses84015403dis_us_es
divested13268213di_vested
dusted83918373d___usted
gusted84316723___gusted
ingested10259003_ingested
misguessed1442493misguessed
misguided14144643misguided
misquoted2144083misquoted
missuited1257003missuited
mistrusted1345423mistrusted
misused104111273mis_us_ed

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 Filter1786911486410.1531167915.0
2DLD Change Limit148641786.98621277.0
3Display Results78780.0302600.0
 (SQL Overall)178691787.16924925.5
 
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.