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

143 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
birles8492064(None) 
bibles104617641bibles
biles75542141bi_les
birle75023631birle_
birled94416991birled
birler85715081birler
birlers93813001birlers
birls74023161birl_s
birses84717731birses
airless73712042airless
aisles64721142aisles
arles56735742_arles
bales76250082b_ales
barbes104526232barbes
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barless94317002barless
barley115116762barley
barleys125011842barleys
barres84427552barres
baryes116218502baryes
belles85325992belles
bermes106023002bermes
bialies93618412bialies
bialis83617162bialis
bialys11387912bialys
biases84618432biases
bible95119422bible_
bibless11439172bibless
bices95029962bi_ces
bides85536782bi_des
bields94110002bields
biflex1834952biflex
bikes117529472bi_kes
bikies124515162bikies
bile66147192bi_le_
bilges94915632bilges
bilks115117892bi_lks
billed94224902billed
biller84923482biller
billers94720832billers
billet86029722billet
billets94516152billets
billies93923502billies
bills75632862bi_lls
bindles104016452bindles
bines76946792bi_nes
binges93923122binges
biomes103815252biomes
birches143412322birches
birded104414302birded
birder94915492birder
birders103913262birders
birdies104016212birdies
birds85421342bir_ds
biremes1138772biremes
birkies133712432birkies
birks114920302bir_ks
birl65830482birl__
biros75325132bir_os
birred94713202birred
birrs74917102bir_rs
birse74517402birse_
births115713602births
bises75435622bi_ses
bites75641172bi_tes
bizes165923662bi_zes
bizzes163910842bizzes
bogles95020832bogles
boles75448602b_oles
bores76448252bor_es
boules84925972boules
braes75735052b_raes
brees75632552b_rees
bribes105918532bribes
brides94423512brides
bridles104114472bridles
bries74942152b_ries
brills84916292brills
brines85028852brines
brises84927612brises
bugles94822442bugles
burbles114916802burbles
burgles105615962burgles
buries84633272buries
burkes124421312burkes
burled94825382burled
burler84723832burler
burlers94120272burlers
burlesk1335462burlesk
burley114715752burley
burleys12479672burleys
burls74228852burl_s
burses84425512burses
butles84423912butles
byres104421382byr_es
byrled12437172byrled
byrls105711232byrl_s
carles85435082carles
circles1139902circles
cires74932912cir_es
dirges84915102dirges
dirled84514902dirled
dirls64720502dirl_s
farles96025782farles
files85441272fi_les
filles94224522filles
fires85740752fir_es
girdles92210002girdles
girlies83013702girlies
girls64518392girl_s
hirees95117292hirees
hires86134342hir_es
hirples12149642hirples
hirsles101510072hirsles
idles66720122_idles
ires45639282_ir_es
isles54220562_isles
kirtles11309662kirtles
lisles63416282lisles
merles85322762merles
miles74645072mi_les
milles84526562milles
mires75640882mir_es
orles55326212_orles
parles86334412parles
piles74742612pi_les
rifles94217712rifles
riles55343642ri_les
rilles64725502rilles
sidles74721152sidles
sirees64624582sirees
sires55945372sir_es
tiles55542102ti_les
tires55437492tir_es
tirled74714362tirled
tirls54519802tirl_s
titles63719922titles
vires84529682vir_es
virls85618602virl_s
wiles85437872wi_les
wires86034912wir_es

Search took 6 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.716249568.4
2DLD Change Limit825511434.79617212.5
3Display Results1431430.0502860.0
 (SQL Overall)1786911435.56232127.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.