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

50 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
twasome124462(None) 
twasomes1344331twasomes
twosome1245301twosome
awesome1245572awesome
trisome9310222trisome
twosomes1345202twosomes
wagsome1345212_wagsome
episome1157813episome
eyesome1246163eyesome
fearsome1345103fearsome
fulsome1245363fulsome
gladsome1244243gladsome
irksome1344373irksome
lissome937583lissome
noisome947963noisome
oxysome1944213oxysome
radome9511873_radome
some66040383___some
tame66343663t_a__me
tasse54821843t_as_se
tassie66017023t_assie
taste55127233t_as_te
tawse85616503taws__e
taxeme1536253t_axeme
tease55428713teas__e
teatime9310083teatime
telome8311923t_elome
tiresome1046993tiresome
toilsome1045203toilsome
tome67543193t___ome
townhome1644053townhome
transom948823transom_
transoms1048933transoms
trashmen1346563trashmen
triseme936543triseme
trisomes1039833trisomes
trisomy1235943trisomy
tussore7317283tussore
twaddle12245713twaddle
twae74719573twa___e
twangle1145803twangle
twas76824083twas___
twattle1064273twattle
ugsome934783_ugsome
wailsome1344493_wailsome
wakame1535433_wakame
wame95035483_wa__me
waste86125053_was_te
winsome1237463winsome
woesome1246733woesome

Search took 9 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.1561145455.1
2DLD Change Limit134027507.96616824.9
3Display Results50500.0461087.0
 (SQL Overall)178691508.16821877.0
 
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.