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

79 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
lingcod114368(None) 
lingcods1243941lingcods
lingo66022112ling_o_
binged105920823bing_ed
bingo86020093bing_o_
bingos95514793bing_os
clinged113310093cling_ed
dinged95221783ding_ed
dingo74720793ding_o_
gingko12376033gingko_
gingkos13405343gingkos
hinged114618923hing_ed
incog838253_in_cog
ingot61221063_ing_ot
jingko18505373jingko_
jingled164111063jingled
jingo134615213jing_o_
kingcup1642473kingcup
kingdom1543543kingdom
kinged124215283king_ed
kinghood1753983kinghood
kingwood1743743kingwood
lanced93717723lan_ced
languid936623languid
languor895423languor
ligand85011293li_gand
limacon1144143limacon
linac7315413linac__
linacs8310813linac_s
linalol745093linalol
linecut997983linecut
lined64934643lin__ed
ling57447963ling___
linga66820823ling__a
lingam95112353ling_am
lingams104510193lingams
lingas75116573ling_as
linger75226003ling_er
lingered10129643lingered
lingers84223303lingers
lingier84113383lingier
lingoes84014693lingoes
lings67135773ling__s
lingua7509913ling_ua
linguae8398413linguae
lingual8379083lingual
lingula8428803lingula
lingy96925143ling__y
linkboy1643173linkboy
linked114518213lin_ked
lino46343373lin__o_
linocut997673linocut
linos55631503lin__os
linseed838203linseed
linted74021823lin_ted
lintol6369473lin_tol
linuron746513linuron
longbow1343863longbow
longed87121373long_ed
lunged85418273lung_ed
minced114114913min_ced
mingled113612733mingled
olingo736933oling_o_
olingos846013oling_os
pinged104321383ping_ed
pingo87122713ping_o_
pingos95317673ping_os
pinguid1146243pinguid
ringed84623843ring_ed
singed85422293sing_ed
singled93914683singled
tinged84220803ting_ed
tingled93712803tingled
winced124415343win_ced
wingbow1643773wingbow
winged114620833wing_ed
zinced18419413zin_ced
zincoid1946663zin_coid
zinged174414623zing_ed

Search took 7 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 Limit134027795.95322514.2
3Display Results79790.0302633.3
 (SQL Overall)178691796.13929107.5
 
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.