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

90 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
gusseted104355(None) 
basseted1136752basseted
cosseted1178342cosseted
guested9157712gues_ted
gusset7316432gusset__
gussets837442gusset_s
gussied9267192guss_ied
gusted84316722gu_s_ted
assented957513_assented
asserted957903_asserted
bassetted1244703bassetted
bucketed1736763bucketed
budgeted1344883budgeted
buffeted1753733buffeted
bugseed1136173bugse_ed
bulleted1138393bulleted
burseed1049503burse_ed
bursted1039423burs_ted
busheled1465273busheled
bussed94717053buss__ed
busted95123153bu_s_ted
casketed1534953casketed
closeted1135613closeted
corseted11311473corseted
curveted1435293curveted
cuspated1335913cuspated
cussed94917123cuss__ed
disseated11711083disseated
dissected13108663dissected
dissented1199723dissented
disserted11109813disserted
dueted84113593du__eted
dusted83918373du_s_ted
fussed104613803fuss__ed
galleted1038223galleted
garreted1057523garreted
gassed85217633gass__ed
gasted84821583g_as_ted
gessoed935743gess_oed
gestated102910573gestated
ghosted1236273ghos_ted
gibbeted1492783gibbeted
gimleted1243973gimleted
gleeted9379323g_leeted
gorgeted1135353gorgeted
gossiped1263513gossiped
greeted93111383g_reeted
grummeted1552153grummeted
guessed9176603gues_sed
guised84612173guis__ed
gumshoed1542703gumshoed
gumweed1433943gumwe_ed
gushed114816243gu_s_hed
gusseting1173963gusseting
gussie72910153guss_ie_
gussies82813303guss_ies
guttated10266873guttated
gutted84716363gu__tted
guttered10259163guttered
isleted837523_isleted
junketed2033523junketed
justed144215773ju_s_ted
lessened935103lessened
lusted74319443lu_s_ted
lustered92510603lustered
masseter1037063masseter
misseated12610113misseated
mussed94418903muss__ed
musted93321073mu_s_ted
mustered112511503mustered
ousted73720583ou_s_ted
poussetted1342323poussetted
pulsated1136853pulsated
quested17168383ques_ted
quieted17309723qu_ieted
russet6319433russet__
russets738163russet_s
russety1034613russet_y
rusted75020923ru_s_ted
suspected1444383suspected
sussed75015533suss__ed
tasseled935603tasseled
turreted935373turreted
tussled835413tuss_led
unsated83419933_unsated
unseated91317683_unseated
unsewed112911023_unsewed
unsexed152410253_unsexed
ushered1139153_ushered
vesseled1243833vesseled

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.406440125.6
2DLD Change Limit146162907.03320782.3
3Display Results90900.0761184.2
 (SQL Overall)178691907.51523777.9
 
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.