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

99 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
giddap114341(None) 
giddyap1541231giddyap
giddy115810202gidd_y
giddyup154862giddyup
goddam1145162goddam
kidnap1334192kidnap
midcap1336472midcap
midday13327502midday
addax1435993_addax
aidman92410623aidman
bidden104010793bidden
bidder104114863bidder
biddy124612693bidd_y
bitmap1235613bitmap
dap66652453___dap
diddle94915213diddle
diddly12389573diddly
fiddle113613383fiddle
fiddly14328483fiddly
gadded103913173gadded
gadder93714713gadder
gaddi85211633gadd_i
gaddis94211373gaddis
gap67055613g___ap
garda7316763garda_
gardai839663gardai
gaydar1135503gaydar
gelcap1136213gelcap
gid57047263gi_d__
giddied11257713giddied
giddier10308723giddier
giddies103713363giddies
giddily1335073giddily
gids65933733gi_d_s
gied64631983gied__
giga66720943gi_ga_
gigas75415583gi_gas
gild65526513gild__
gilded94413223gilded
gilder84415533gilder
gilds75417523gild_s
gimbal11228813gimbal
gimmal11247513gimmal
gimp96124043gi__mp
gingal81010143gingal
gip67645363gi___p
gird65424993gird__
girded93712493girded
girder84312063girder
girdle82110463girdle
girds74816993gird_s
goddamn1242673goddamn
goddams1233983goddams
godded104811803godded
gridded11387583gridded
gridder10367763gridder
griddle1035503griddle
hidden11429743hidden
idea59122773_idea_
ideal65716393_ideal
ideas65919013_ideas
keddah1534263keddah
kidded13299383kidded
kidder123811093kidder
kiddie12359393kiddie
kiddo11398943kidd_o
kiddos12416863kiddos
kiddy144910273kidd_y
kidnaps1453323kidnaps
lidar6312723li_dar
lidded93410243lidded
madcap1336333madcap
middays14335663middays
midden104112853midden
middle103414983middle
middy124812593midd_y
midway15327153midway
mishap1338863mishap
mudcap1335133mudcap
nidal65217103ni_dal
oidia6314953oidia_
piddle103514913piddle
piddly13319143piddly
qindar16317173qindar
redcap1158493redcap
ridded93615123ridded
ridden83511723ridden
ridder84015143ridder
riddle83915713riddle
riprap1055513riprap
siddur834573siddur
sirdar7269103sirdar
tidal64516443ti_dal
tiddly11308783tiddly
widder112913973widder
widdie113410733widdie
widdle113814843widdle
widdy136112183widd_y
windup1235383windup

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 Filter1786911127160.1431249587.4
2DLD Change Limit112716995.90619085.0
3Display Results99990.0303300.0
 (SQL Overall)178691996.07929394.8
 
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.