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

151 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
birse7451740(None) 
birle75023631birle
birses84717731birses
bise66437101bi_se
burse75527251burse
airs46447422airs_
arise56436432arise
arse46539272_arse
barbe95328282barbe
barde85330772barde
bare65460522bar_e
bares75457132bares
barge85631022barge
barre75929552barre
bars66564092bars_
barye105021492barye
base64847022b_ase
berme96022942berme
bias64738162bias_
biased94012222biased
biases84618432biases
bible95119422bible
bibs84830992bibs_
bice86235562bi_ce
bices95029962bices
bide76041502bi_de
bides85536772bides
bids75838452bids_
biers76225222biers_
bigs76235022bigs_
bike106532602bi_ke
bikes117529472bikes
bikie113915882bikie
bile66147182bi_le
biles75542142biles
bilge87618912bilge
bine66650862bi_ne
bines76946792bines
binge85125512binge
bins66548252bins_
biome94916992biome
bios66335322bios_
birch124914022birch
bird76128322bir_d
birded104414302birded
birder94915492birder
birdie94013782birdie
birds85421332birds
bireme10310142bireme
birk106326862bir_k
birkie124110132birkie
birks114920302birks
birl65830472bir_l
birled94416992birled
birler85715082birler
birles84920642birles
birls74023162birls
biro66131212bir_o
biros75325132biros
birr66022362bir_r
birred94713202birred
birrs74917102birrs
birth105619872birth
bis56860662bi_s_
bises75435622bi_ses
bisk106523352bi_sk
bite66547002bi_te
bites75641172bites
bits66148162bits_
bitsy104511302bitsy
bize155926292bi_ze
bizes165923662bizes
blase75524232blase
bore66051332bor_e
bores76448252bores
borne77926792borne
bourse84414332bourse
bouse75931852bouse
bowse105420632bowse
brae65639112b_rae
bree67241262b_ree
bribe94820782bribe
bride86425532bride
brie65837902b_rie
bries74942152bries
brine75132272brine
bris65539612bris_
brises84927612brises
brisk115615982brisk
briss75824272briss
brose75227032brose
burke115122762burke
burs65847422burs_
bursa74921522bursa
bursae84515602bursae
burses84425512burses
burst75332242burst
byre95023852byr_e
byres104421382byres
carse74934332carse
cire65836372cir_e
cires74932912cires
corse75036182corse
curse75829142curse
dire56644142dir_e
dirge75117072dirge
fire76245592fir_e
fires85740752fires
firs76637712firs_
first86226122first
frise85322452frise
girsh95310022girsh
gorse65926812gorse
hire75538962hir_e
hiree85427802hiree
hires86134342hires
hirsel9138682hirsel
hirsle9159572hirsle
horse86132652horse
ire36943172_ir_e
ires45639282_ires
kirs85831742kirs_
lire47845292lir_e
marse76231152marse
mire66748232mir_e
mires75640882mires
mirs66940572mirs_
mise66043582mi_se
morse76032702morse
nurse54420122nurse
parse75236992parse
perse75429522perse
prise74632612prise
purse76028892purse
rinse54820972rinse
rise45945232ri_se
sire46150412sir_e
siree55238812siree
sires55945372sires
sirs44338332sirs_
terse55026822terse
tire46143352tir_e
tires55437492tires
torse55833332torse
verse84723582verse
vires84529682vires
vise75632672vi_se
wire75839812wir_e
wires86034912wires
wise75737342wi_se
worse86525262worse

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 Filter178691538000.296603685.8
2DLD Change Limit538001511.70331591.3
3Display Results1511510.0463282.6
 (SQL Overall)1786911512.04587379.5
 
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.