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

275 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
bedsits103756(None) 
bedsit9312841bedsit_
beasts84519722beas_ts
bedims1149592bed_ims
bedside1156842bedside
bedsides1246532bedsides
beduins1039122beduins
befits114711502be_fits
bemists113410702bemists
besets85718802be_sets
besots86415452be_sots
bests75932612be_s_ts
edits65819032_ed_its
resits64725562re_sits
adits66523713_ad_its
admits9411413_admits
audits72814113aud_its
babysits15143543babysits
baddies114017873baddies
baits76630583b__aits
bandits103814793bandits
bankits133410153bankits
basics104915123b_asics
basils85717473b_asils
basins85722763b_asins
basis75429863b_asi_s
bassets96414823bassets
bassist9312743bassist
bassists1037183bassists
basts75936933b_as_ts
beanies93821093beanies
beast76338643beas_t_
beastie92412433beastie
beasties102514653beasties
beats76042243be__ats
beauts86015283be_auts
beckets15399823beckets
bedamns1235733bedamns
bedaubs1233693bedaubs
bedbugs13193503bedbugs
bedders113513383bedders
bedding124114483bedding
beddings13407923beddings
bedecks1635793bedecks
bedells10379363bedells
bedels94015273bed_els
bedevils1444373bedevils
bedews12398943bed_ews
bedfast1346413bedfast
bedights1544743bedights
bedim10313833bed_i_m
bedirty1344183bedirty
bedlams1237053bedlams
bedless1039703bedless
bedlike14369533bedlike
bedmate1239433bedmate
bedmates1349183bedmates
bedouins1145513bedouins
bedpans1237173bedpans
bedpost1247243bedpost
bedposts1343873bedposts
bedquilts2141633bedquilts
bedrails1136293bedrails
bedrid1039943bedri_d
bedrugs11194283bedrugs
beds75937783bed___s
bedsheets1542943bedsheets
bedsonias1243013bedsonias
bedsore1057803bedsore
bedsores1157633bedsores
bedtick1645233bedtick
bedticks1774163bedticks
bedtime1236973bedtime
bedtimes1336593bedtimes
beduin939713bedui_n
bedumbs1433633bedumbs
beedies10314203beedies
beets76131443be__ets
befit105222663be_fit_
befrets1237613befrets
begets96215523be_gets
begins94415303be_gins
begrims1276763begrims
behests1235953behests
bekiss1236373be_kiss
beknots1335083beknots
belies84631053be_lies
bellies94023723bellies
belts75931163be__lts
bemist105216963bemist_
benefits1345713benefits
bennets94712163bennets
bennies93917313bennies
bennis84314803benni_s
bents76033693be__nts
benzins1838693benzins
bepaints1235113bepaints
berets85822523be_rets
berlins93216013berlins
berries94423553berries
beses75830723be_s_es
beset76739133be_set_
beside95114613be_side
besides104814533be_sides
besmuts1134683besmuts
besoms105712733be_soms
besot76429713be_sot_
best66355323be_s_t_
bestir8311163be_stir
bestirs9311133bestirs
betises94816123betises
bets67051443be___ts
bevies114017303be_vies
bevomits1543463bevomits
bewails1277553bewails
bewigs1246533be_wigs
beylics1436183beylics
beyliks1634853beyliks
bezants1877343bezants
bezils1711310603be_zils
biddies113514493biddies
bidets95215533bid_ets
bidis86721143bid_i_s
binits85716673b_inits
bits66148163b___its
blasts85116773blas_ts
boasts85017923boas_ts
bodies94524143bod_ies
bodkins1438313bodkins
bodysuits1582223bodysuits
boosts86115013boos_ts
borshts1266543borshts
bossies94116833bossies
brasils9410973brasils
breasts939703breas_ts
brits76433083b__rits
bruits85714453b_ruits
buddies113914353buddies
budgets11489863budgets
budgies115312513budgies
bundists1145383bundists
bursitis1045033bursitis
bursts85116243burs_ts
busies85525263b_usies
busts75227693b_us_ts
cedis84317083ced_i_s
cesspits1243663cesspits
coedits10310243coed_its
credits1039973cred_its
debits94214503de_bits
deceits102810883deceits
deducts1166593deducts
deists74916433deis_ts
delists84414173delists
demits94918073de_mits
density1137583density
deposits1138843deposits
desist74818813de_sist
desists83611723de_sists
dits56450523__d_its
doits66223673__doits
duits65021883__duits
easies64126633_easies
easts57530323_eas_ts
eddies83313163_eddies
edicts94911703_edicts
edit54934863_ed_it_
educts9439893_educts
emits75421473_e_mits
eosins64419163_eosins
exists134710913_exists
exits125515913_e_xits
feasts95116093feas_ts
feists94915313feis_ts
felsite1039083felsite
felsites1138073felsites
fests85828043fe_s_ts
feudists1244463feudists
geests75912163gees_ts
gests66028813ge_s_ts
godwits1234133godwits
headsets1236053headsets
heists96814633heis_ts
henbits12177003henbits
hermits12312143hermits
hessite1038993hessite
hessites1138613hessites
hests85829933he_s_ts
jests125922453je_s_ts
jesuits1436323jesuits
keysets1434343keysets
leasts64616413leas_ts
legists899593legists
legits71313003le_gits
medias93620783med_ias
medics114115353med_ics
medius93613283med_ius
merits8320873me_rits
midsts95510053mids_ts
neddies92710703neddies
nests55728003ne_s_ts
newsies101310383newsies
nudists8356833nudists
obesity1275653obe_sity
odists749853_odists
outsits73215253outsits
pedants10310113pedants
peewits12105873peewits
pensils92811593pensils
pepsins11310433pepsins
permits11314003permits
persist9315853persist
persists1049183persists
pests75933273pe_s_ts
pewits112810683pe_wits
posits85718713_posits
readmits1136653readmits
rebaits9312573rebaits
recits83621353re_cits
redacts10510943redacts
redbaits1135903redbaits
redfins1139923redfins
redias74523603red_ias
redips93713843red_ips
redouts81411663redouts
redries83721713redries
redshifts1642573redshifts
redshirts1342903redshirts
redskins1385873redskins
reedits8511743reedits
reemits9611303reemits
reests64618893rees_ts
refits94017653re_fits
reknits1137073reknits
relists73817053relists
remits85622943re_mits
reposits10310453reposits
resets65427613re_sets
resids74219153re_sids
resifts10378703re_sifts
resins64528773re_sins
resist64524533re_sist
resists74414923re_sists
resit54241043re_sit_
resite64128453re_site
resites74027793re_sites
rests54935873re_s_ts
revisits1137423revisits
sadists83310853sadists
seisins73614393seisins
sennits73811283sennits
sepsis83011293sepsi_s
sexists14267673sexists
sits45050203___sits
subedits1146713subed_its
teddies92711283teddies
tensity1039103tensity
territs72714503territs
testis64916713te_stis
tests56530193te_s_ts
tidbits1035183tidbits
verists103613673verists
versets103913103versets
versts93914733vers_ts
vests85325983ve_s_ts
visits9311423_visits
wadsets1136443wadsets
website1235323website
websites1335183websites
wedgies123910213wedgies
weskits1434743weskits
wests85727003we_s_ts
wetsuits1143233wetsuits
yeasts96413053yeas_ts
zests145419743ze_s_ts

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 Filter1786911340270.440406115.9
2DLD Change Limit1340272756.17021722.4
3Display Results2752750.0962864.6
 (SQL Overall)1786912756.70626646.4
 
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.