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

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
dingbat114698(None) 
dingbats1245011dingbats
diagram1147363diagram
digest84019623di_gest
dight104027003di_g_ht
digit73825273di_g_it
diglot83014333di_glot
diktat11310693di_ktat
dinar66319893din__ar
ding66940953ding___
dinge75627303ding__e
dinged95221783ding_ed
dinger85323673ding_er
dingers94321383dingers
dinges83825423ding_es
dingey114914053ding_ey
dingeys12458403dingeys
dinghy14476963ding_hy
dingier93513673dingier
dingies93618243dingies
dingiest102915373dingiest
dingily1238103dingily
dinging103618613dinging
dingle84317073ding_le
dingles93818323dingles
dingo74720793ding__o
dingoes94114833dingoes
dings76331403ding__s
dingus83611843ding_us
dingy105721263ding__y
dint56759053din___t
diquat1639763di_quat
dirtbag1143023dirtbag
disbar938513di_sbar
disgust937633disgust
disseat83816923disseat
donga76718423dong_a_
dongas84914613dong_as
gingal81010153ging_al
gingham1484463gingham
ingate73018243_ing_ate
ingest73119003_ingest
ingot61221063_ing_ot
ingraft1199503_ingraft
ingrate8715123_ingrate
jingal1498593jing_al
kingbolt1544183kingbolt
kinglet123114043kinglet
linga66820823ling_a_
lingam95112353ling_am
lingas75116573ling_as
lingua7509913lingua_
linguae8398413linguae
lingual8379083lingual
longboat1146093longboat
minibar11106133minibar
pigboat1247823pi_gboat
ringbark1544053ringbark
ringbolt1145073ringbolt
ringent8315153ringent
ringgit946013ringgit
ringlet82818173ringlet
ringtaw1154363ringtaw
singlet84120113singlet
windbag1444123windbag
wingback2044403wingback
wingbow1643773wingbow
winglet113115983winglet
wingman1336383wingman

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 Filter1786911340270.390458182.1
2DLD Change Limit134027696.67320085.0
3Display Results69690.0135307.7
 (SQL Overall)178691697.07625253.1
 
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.