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

74 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
kidvids164311(None) 
kidvid1535021kidvid_
kiddies133412282kiddies
biddies113514493biddies
bidis86721143bid_i_s
bovids1287973_bovids
civics13397823ci_vics
civies114116443ci_vies
civvies1555843civvies
corvids1337683corvids
diacids1137863diacids
didies84621833did_ies
dioxids1655683dioxids
divide113410893di_vide
divides123211453di_vides
divvies1457663divvies
gadids95611823gad_ids
gadoids1036873gadoids
giddies103713363giddies
hydrids15267233hydrids
imids86015143_i_mids
iodids83711153_iodids
irids66417773_i_rids
ivies84215763_i_vies
kadis105921063kad_i_s
keloids1288663keloids
kelvins14106563kelvins
kevils13358333k_evils
kibbis14398473kibbi_s
kibeis12469803kibei_s
kidded13299393kidded_
kidders13399173kidders
kiddie12359393kiddi_e
kidding14389773kidding
kiddish16276583kiddish
kiddo11398953kid__do
kiddoes13387063kiddoes
kiddos12416863kid_dos
kiddy144910283kid__dy
kidlike1137063kidlike
kidnaps1453323kidnaps
kidneys1533423kidneys
kids96029643k___ids
kidskins1243453kidskins
kilims1277903ki_lims
killies113318113killies
kilties113014143kilties
kindreds14274013kindreds
kinds106221823ki__nds
kinins104014583ki_nins
kitties113213623kitties
kivas124614733ki_v_as
kiwis12328583ki_wi_s
lipids94310923li_pids
lipoids1038233lipoids
liquids1735823liquids
livid96714423li_vid_
midairs1037203midairs
middies113116153middies
midis85923413mid_i_s
midribs1235513midribs
nitrids8269633nitrids
pidgins11259123pidgins
ridgils9326573ridgils
sialids839723sialids
silvics1235563silvics
skivvies18112883skivvies
tidbits1035183tidbits
tidies74721833tid_ies
tineids8337873tineids
vids85627543___vids
viroids1137923viroids
vivid125112313vi_vid_
widdies123514033widdies

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.406440125.6
2DLD Change Limit134027746.78019768.0
3Display Results74740.0302466.7
 (SQL Overall)178691747.21624763.2
 
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.