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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

132 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
kidvid153503(None) 
kidvids1643111kidvids
kidded13299402kidded
kiddie12359402kiddie
livid96714422li_vid
vivid125112312vi_vid
aided75828943aid_ed
avid88325973__avid
bedrid1039943bedrid
bided95424973bid_ed
bidi78226603bid_i_
bidis86721153bid_is
bifid11910703bi_fid
bovid111011623_bovid
cervid1239323cervid
civic123412543ci_vic
civie103716353ci_vie
civil103411933ci_vil
corvid12310473corvid
diacid10310633diacid
did56850533__d_id
didie74120573did_ie
dioxid1568393dioxid
dived106321373di_ved
divide113410893di_vide
divvied1544813divvied
fervid1337513fervid
fidged124610933fidged
gadid85517383gad_id
gadoid9310463gadoid
giddied11257713giddied
gravid113710983gravid
hided105222453hid_ed
hispid1238173hispid
hived125217913hi_ved
hydrid14248973hydrid
idled74915213_idled
imid76122303_i_mid
iodid74315533_iodid
irid55927183_i_rid
ivied94710523_i_vied
jived165115043ji_ved
kadi96224843kad_i_
kadis105921073kad_is
kedged13439753kedged
keloid11812623keloid
kelvin13117323kelvin
kevil12399863k_evil
kibbi13449283kibbi_
kibbis14398473kibbis
kibei114311543kibei_
kibeis12469803kibeis
kicked124415943kicked
kid86540633k___id
kidder123811113kidder
kiddies133412283kiddies
kidding14389773kidding
kiddish16276583kiddish
kiddo11398963kid_do
kiddos12416873kiddos
kiddy144910293kid_dy
kidlike1137063kidlike
kidnap1334203kidnap
kidney1434773kidney
kids96029653kid__s
kidskin1143833kidskin
kilim11711903ki_lim
killed113918773killed
killie104114893killie
kilned11368393kilned
kilted113613833kilted
kiltie103210963kiltie
kind96128573ki__nd
kindled133410543kindled
kindred13316953kindred
kinged124215293kinged
kinin94917333ki_nin
kinked104014753kinked
kipped153114573kipped
kirned11408623kirned
kissed114412853kissed
kited105120103ki_ted
kithed144613013kithed
kitted115114833kitted
kiva116516423ki_v_a
kivas124614743ki_vas
kiwi113211813ki_wi_
kiwis12328593ki_wis
lidded93410243lidded
limpid11389753limpid
lipid85916173li_pid
lipoid9411043lipoid
liquid1637143liquid
lived95523723li_ved
midair937993midair
midi75628493mid_i_
midis85923423mid_is
midrib1138243midrib
misdid10510573misdid
nided75920883nid_ed
nidi56524413nid_i_
nitid61817833ni_tid
nitrid72812233nitrid
oidia6314963oid_ia
oidioid946053oidioid
pavid115717003_pavid
pidgin10259813pidgin
redid74922393red_id
ridded93615123ridded
ridged94014223ridged
ridgil8316823ridgil
rigid7913893ri_gid
rived94825613ri_ved
sialid7314943sialid
sided74825963sid_ed
sidled84215173sidled
sieved104611443sieved
skidded1465083skidded
skived14429893ski_ved
skivvied1971813skivvied
tidbit938493tidbit
tided76322523tid_ed
tidied83613273tidied
timid84815733ti_mid
tineid74412023tineid
undid72415363und_id
vid77241823___vid
virid94116043vi_rid
viroid10411523viroid
viscid1237473viscid
widdie113410733widdie
wived125121503wi_ved

Search took 6 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.390458182.1
2DLD Change Limit1127161325.00022543.2
3Display Results1321320.0502640.0
 (SQL Overall)1786911325.44032847.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.