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

125 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
bedrails113629(None) 
bedrail1037251bedrail_
becrawls1543622becrawls
bedevils1444372bedevils
bedrapes1386962bedrapes
bedrolls1144672bedrolls
bewails1277552be_wails
brails84621292b__rails
derails84216392de_rails
drails74716952__drails
redtails968002redtails
serails73318362se_rails
aerials74017553ae_rials
bails75933523b___ails
beadrolls1243773beadrolls
bearable121512363bearable
bearably15177933bearably
becrawl1444583becrawl_
bedamns1235733bed_amns
bedaubs1233693bed_aubs
bedchairs1742603bedchairs
beddable14166923beddable
bedells10379363bed_ells
bedels94015273bed__els
bedevil1344513bedevil_
bedframes1743013bedframes
bedims1149593bed__ims
bedirties1275683bedirties
bedlamps1543663bedlamps
bedlams1237053bedla_ms
bedmates1349183bedmates
bedouins1145513bedouins
bedpans1237173bedpa_ns
bedquilt2043453bedquilt
bedquilts2141633bedquilts
bedraggle1442123bedraggle
bedraggles1541863bedraggles
bedrape1277693bedra_pe
bedraped1455813bedraped
bedraping1535383bedraping
bedrid1039943bedr_i_d
bedrivels1542713bedrivels
bedrocks1745333bedrocks
bedroll1055553bedr_oll
bedrooms1345713bedrooms
bedrugs11194283bedr_ugs
bedsits1037563bed_sits
beduins1039123bed_uins
bedwards1596393bedwards
bedwarfs17113583bedwarfs
befalls12349123be_falls
begalls10319163be_galls
begrims1276763begr_ims
berakes134815773be_rakes
berates94126873be_rates
berlins93216013be_rlins
berries94423553be_rries
beryls11107883be_r_yls
betrayals1442963betrayals
betrays12127823betra_ys
bewail1189583be_wail_
bewraps14135403bewra_ps
bewrays15145113bewra_ys
bezils1711310603be__zils
bharals1236733bhara_ls
bobtails1245193bobtails
borals86721913b_ora_ls
braids95015693b__raids
brail75525553b__rail_
brains85125473b__rains
brasils9410973b__rasils
brawls115214333b__rawls
brazils1867753b__razils
broils84114173b__roils
burials93612083b_urials
decrials1137133decrials
derail74218813de_rail_
details84214043de_tails
detrains9411763detrains
drail65020973__drail_
drains73719403__drains
drawls105511393__drawls
emails84412343_e_mails
engrails945383engrails
entails7912823_entails
entrails8310163entrails
ervils948773_e_rvils
federals1247303federa_ls
ferals94216643fe_ra_ls
frails93716473__frails
gerbils1037303ge_rbils
grails77518783__grails
handrails1346513handrails
headsails1343943headsails
jezails2334163je_zails
medals94218053med_a_ls
medials103914733media_ls
pedals94316033ped_a_ls
perils84121853pe_r_ils
rails55937403___rails
reavails1134853reavails
redbaits1135903redbaits
redials84416883redia_ls
redrafts1235603redrafts
redraws11218473redra_ws
redries83721713redr_ies
redrill857893redr_ill
redrills956083redrills
redtail858713redtail_
refrains1139593refrains
remails94714563re_mails
renails74917263re_nails
resails74616743re_sails
retails74718973re_tails
retrains8314533retrains
retrials8510823retrials
serail64222673se_rail_
serais64326133se_rai_s
serials73919743se_rials
tenails73713923te_nails
tendrils946443tendr_ils
terais64023513te_rai_s
terrains8410323terrains
trails64622513__trails
ventails1139823ventails

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.1561145455.1
2DLD Change Limit1461621257.48319532.5
3Display Results1251250.0631984.1
 (SQL Overall)1786911257.70223200.6
 
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.