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 “twangs” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

69 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
twangs1035809(None) 
tangs65028341t_angs
twang94511851twang_
twangy13386981twangy
bangs85627772_bangs
bhangs12449662bhangs
bwanas1157442bwanas
changs125215372changs
clangs95113612clangs
dangs75623202_dangs
fangs96224072_fangs
gangs76222572_gangs
hangs95726722_hangs
kiangs11378362kiangs
liangs74410592liangs
orangs74116032orangs
pangs84628662_pangs
prangs94816232prangs
slangs75615342slangs
stangs75018162stangs
swags94921252swa_gs
swang95519722swang_
swanks134811562swanks
swans84625012swan_s
swings104714452swings
tags55545232t_a_gs
tang56138662t_ang_
tanga64923682t_anga
tango66921172t_ango
tangos74216302t_angos
tangy94519932t_angy
tanks94624732t_anks
tans46154812t_an_s
thanes94918982thanes
thanks134313132thanks
things104914282things
thongs104611182thongs
tings65329192t_ings
tongs65928462t_ongs
tranks104017762tranks
tranqs155210312tranqs
trans54933042tran_s
tungs65520622t_ungs
twaes86513662twa_es
twains95811182twains
twanged12387272twanged
twanger11327432twanger
twangers12226062twangers
twangle1145802twangle
twangles1245742twangles
twanky16445772twanky
twas76824082twa__s
twats86616602twa_ts
twigs96911172tw_igs
twines94717272twines
twinge104210392twinge
twinges11409442twinges
twins85118982twin_s
vangs96319582_vangs
wags86140552_wa_gs
wands96425482_wands
wanes85040882_wanes
wanks126124482_wanks
wans76452262_wan_s
wants87932212_wants
whangs13439722whangs
wings95727242_wings
wrangs104611912wrangs
yangs95618692_yangs

Search took 3 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 Filter178691825510.1231452772.4
2DLD Change Limit82551692.83029170.0
3Display Results69690.0135307.7
 (SQL Overall)178691692.96660246.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.