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

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

109 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
burans8501930(None) 
brans75437431b_rans
buran75225301buran_
buras74736301bura_s
burins84221891burins
burns74926781bur_ns
furans94515951furans
anurans73810552anurans
auras55932562aura_s
bans66555142b__ans
barns76335142bar_ns
barons85025382barons
beans75734692b_eans
bogans95714812bogans
borals86721912borals
borane84620212borane
boranes93720402boranes
boras75938302bora_s
borons85520542borons
bourns84114062bour_ns
brads85528292b_rads
braes75735052b_raes
brags85625102b_rags
brains85125472b_rains
bran65740382b_ran_
brand85124492b_rand
brands95118942b_rands
brank115222282b_rank
branks124817382b_ranks
brant74742172b_rant
brants85723052b_rants
bras65746452b_ra_s
brass75428022b_rass
brats75336012b_rats
brawns115614082b_rawns
braws106425192b_raws
brays106723112b_rays
brens75823362b_rens
brins75533972b_rins
bruins86014952bruins
bubals103513842bubals
bunas75126572buna_s
bunns74718292bu_nns
buns66243722bu__ns
bura66139532bura__
burbs95423492bur_bs
burdens1039712burdens
burds84626062bur_ds
bureaus979292bureaus
burets84321262burets
burghs12519922burghs
burgs84924092bur_gs
burials93612082burials
buries84633272buries
burin75626062burin_
burkas124513802burkas
burkes124421312burkes
burlaps1156252burlaps
burls74228852bur_ls
burn65636432bur_n_
burnt75230332bur_nt
burps94220172bur_ps
burqas174410902burqas
burros85114992burros
burrs74925652bur_rs
burs65847422bur__s
bursars94510892bursars
bursas85318272bursas
burses84425512burses
bursts85116242bursts
burtons9310852burtons
butane8313652butane
butanes9312742butanes
curns74924282cur_ns
currans9310612currans
duras65727732dura_s
durians839572durians
durns64819872dur_ns
furan84320012furan_
furane94015492furane
furanes103214862furanes
grans64832542_grans
guans64419442gu_ans
humans112312432humans
jurant134216552jurant
jurants14379212jurants
jurats134213202jurats
kurgans12145652kurgans
lorans65117602lorans
lurdans837072lurdans
murals84016762murals
muras75329582mura_s
ourang73311062ourang
ourangs8318502ourangs
purana8712932purana
puranas9712642puranas
purins83722652purins
pyrans11411062pyrans
queans153110752queans
sarans64224432sarans
surahs94515542surahs
suras55336332sura_s
trans54933042_trans
turbans939562turbans
turns55623242tur_ns
ulans54921302_ulans
urns46323902_ur_ns
yuans84613322yu_ans
yulans958672yulans

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511092.14038575.2
3Display Results1091090.0333303.0
 (SQL Overall)1786911092.51671021.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.