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

108 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
beloveds1415396(None) 
beloved13188391beloved_
behoved16205562behoved_
behoves15177352behove_s
allovers1137673allovers
baloneys1334663baloneys
beavers124417323be_avers
bebloods13115233beblo_ods
beclouds1345373beclo_uds
becomes132911963become_s
bedcovers1783563bedcovers
beeves114615043be_eve_s
beflowers17165823beflowers
behaved16176683behaved_
behavers16205613behavers
behaves15198523behave_s
beholds1336423beho_lds
behooved1743133behooved_
behooves1653793behoove_s
behove14207203behove__
belaced124112153belaced_
belated103520013belated_
belauds1036643bel_auds
belayed133610083belayed_
belayers13298143belayers
belched154011843belched_
belchers153510023belchers
belches143514343belche_s
belied95022163bel_ied_
beliefs12448583bel_iefs
beliers94617383bel_iers
belies84631053bel_ie_s
believed14427923believed_
believers14346633believers
believes13449403believes
belive115415303belive__
belled94626183bel_led_
belleeks1444363belleeks
belles85325993bel_le_s
bellied104314073bellied_
bellies94023723bellie_s
bellowed14158603bellowed_
bellowers14177623bellowers
belonged1235313belonged_
belongs10408223belo_ngs
belons84119413belo__ns
belows114614183belo__ws
belted94020633bel_ted_
belters93819413bel_ters
beltless10297713beltless
berobed1238233berobed_
beslaved1435023beslaved_
betokens14324573betokens
bevels113913983be__vels
beyonds1335063beyo_nds
bilevels1343693bilevels
bilobed1235913bilobed_
bilsteds1134273bilsteds
bleeds95211593b_l_eeds
blokes123813883b_loke_s
blondes104213163b_londes
blonds95213343b_lo_nds
bloods94614843b_lo_ods
blowed125016693b_lowed_
blowers124313593b_lowers
boilovers1444103boilovers
boloneys1334503boloneys
bovids1287973b__ovids
clovers125114663_clovers
cloves114918823_clove_s
coloreds1138093coloreds
delivers123310753delivers
delved114112753del_ved_
delvers113411993del_vers
delves104917083del_ve_s
elevens1066803_elevens
elodeas836963_elodeas
eloped95914143_eloped_
elopers95112943_elopers
elopes85918163_elope_s
elvers93814983_el_vers
elves85118743_el_ve_s
gloved114811873_gloved_
glovers114310883_glovers
gloves104115183_glove_s
helved134313703hel_ved_
helves124316063hel_ve_s
keloids1288663kelo_ids
loved95021363__loved_
lovers94223433__lovers
loves85332013__love_s
meloids10911453melo_ids
pelves114514663pel_ve_s
plovers123611833_plovers
recovers133511123recovers
releves103914973releve_s
relived115114683relived_
relives104619443relive_s
reloads8911313relo_ads
removed134611313removed_
removers13449223removers
removes124514713remove_s
selves94119613sel_ve_s
slovens10316573_slovens
telomes9310533telome_s
unbeloved1543923unbeloved_
unloved112310533unloved_
velvets13326693vel_vets

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621087.19020328.5
3Display Results1081080.0303600.0
 (SQL Overall)1786911087.64023388.9
 
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.