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

309 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
bisect1031287(None) 
bisects1137131bisects
basest84720492basest
beset76739132bese_t
bidet84935622bide_t
bise66437102bise__
bisected1336202bisected
bisector1245192bisector
bises75435622bise_s
direct93817332direct
disject17268672disject
dissect103614132dissect
exsect1558502exsect
insect83916582insect
misact10316682misact
miseat82925702miseat
resect84424702resect
sect67443622__sect
trisect939732trisect
wisent93516342wisent
wisest95016442wisest
abject17137703abject
absent84016993absent
advect12309123advect
affect1448903affect
airest63825263airest
aspect10612823aspect
assent65119953assent
assert64922583assert
asset55932263asse_t
barest85327693barest
basalt83519583basalt
base64847023base__
based85331583base_d
basely114412313basely
baser74828923base_r
bases75644353base_s
basic96220523basic_
basics104915123basics
basilect1245903basilect
basket125722913basket
basset85225383basset
bassett94213863bassett
bast66362413bas__t
beat66168303b__eat
beck126226573b__eck
bedeck1536213bedeck
beech124315503b_eech
beet66457543b__eet
beget85632563bege_t
behest11314613behest
belt65754033b__elt
bent67759913b__ent
bereft114317303bereft
beret74946363bere_t
beseech1453873beseech
beseem1069083beseem
beses75830723bese_s
besets85718803besets
besmut10310653besmut
besot76429713bes_ot
best66355323b__est
bet58376673b__e_t
bewept13410323bewept
biased94012223biase_d
biases84618433biase_s
bibelot1167343bibelot
bice86235563bi__ce
bicep115413543bice_p
biceps12447713biceps
bices95029963bice_s
bide76041483bide__
bided95424963bide_d
bider85728373bide_r
biders94822803biders
bides85536773bide_s
bidets95215533bidets
bield84614653bi_eld
bier65531833bi_e_r
biers76225223bi_ers
biface1358103biface
bigeye1236643bigeye
bigfeet1376153bigfeet
biggest1138143biggest
bight118728843bi_ght
bigot84828323bi_got
bike106532603bike__
biked125320033bike_d
biker116022563bike_r
bikers124517553bikers
bikes117529473bike_s
bile66147183bile__
biles75542143bile_s
billet86029723billet
bine66650863bine__
biner75930693bine_r
biners85023633biners
bines76946793bine_s
binit76431583bi_nit
binocs1039923binocs
bint67355043bi__nt
biont7727163bi_ont
biotech14104493biotech
bipack1636523bipack
biped104718833bipe_d
bipeds11458053bipeds
birch124914023bi_rch
bireme10310143bireme
biretta947243biretta
birse74517403birse__
birses84717733birse_s
bis56860663bis___
biscuit1147373biscuit
bisecting1436973bisecting
bisection13136983bisection
bisectors1345733bisectors
bisectrix2051853bisectrix
bishop1336943bishop
bisk106523353bis__k
bisks115416803bis_ks
bismuth1443723bismuth
bison75716983bis_on
bisons83914373bisons
bisque17257843bisque
bistate9313823bistate
bister84922763bister
bisters93922613bisters
bistort91216523bistort
bistre83815023bistre
bistro8339943bistro
bit57070903bi___t
bitch125017763bi_tch
bite66547003bite__
biter75030033bite_r
biters83925243biters
bites75641173bite_s
bitsiest102610063bitsiest
bitt65545813bi__tt
bize155926293bize__
bizes165923663bize_s
bleat75737003b_leat
blent76230953b_lent
blest76431723b_lest
blet66247673b_le_t
bluest84016483bluest
bluet75631193blue_t
bosket124919223bosket
bract96332723b_ract
breech13348263breech
brent75734133b_rent
brisant9312683brisant
brises84927613brise_s
briskest14337803briskest
brisket134413403brisket
buret77444013bure_t
bused85624493buse_d
buses75936013buse_s
busiest93716303busiest
bust65947783bus__t
cisco95112133cis_co
cist67244963cis__t
civet105828733cive_t
cosec96320183cosec_
cosecs105015213cosecs
coset75748843cose_t
cusec94614903cusec_
cusecs10509153cusecs
defect124816173defect
deject164512843deject
desert72725493desert
detect94217403detect
dialect101210263dialect
didact10711203didact
diet57357533di_e_t
digest84019623digest
dioecy1235543dioecy
directs102710263directs
direst75024243direst
disc76123233dis_c_
disced104914653disced
discept12310623discept
disci85815023dis_ci
disco85616073dis_co
discs85316263dis_cs
diseur738843diseur
disjects18275923disjects
disseat83816923disseat
dissects11279243dissects
dissent84018683dissent
dissert83720693dissert
distent84120853distent
divert103922813divert
divest106820073divest
effect1437443effect
eject145016043_eject
elect74327033_elect
erect74129333_erect
expect1758903expect
exsects1655573exsects
exsert13414363exsert
filet85540163file_t
finest94321733finest
fisc96819753fis_c_
fiscs105311883fis_cs
fist76248423fis__t
gist56046763gis__t
hist76551543his__t
ibises83610543ibise_s
inept73622153_inept
inert53234373_inert
infect113413443infect
inject153210233inject
insects93710843insects
insert64325253insert
inset54430863inse_t
inspect1138463inspect
islet54527553_islet
kismat123011673kismat
kismet123414623kismet
kist86540793kis__t
likest104914383likest
linecut997983linecut
lisente71210703lisente
list47055343lis__t
livest95315733livest
misacts1139353misacts
miscut10614813miscut
mise66043583mise__
miseats92815783miseats
misedit10311043misedit
miser75430403mise_r
misers85025703misers
misery114113543misery
mises74740563mise_s
misfit112813833misfit
mishit112618193mishit
miskept1538923miskept
mislit83019693mislit
mismeet113215163mismeet
mismet103722373mismet
misseat93617233misseat
missent94318713missent
misset85028153misset
mist66154533mis__t
nicest82315663nicest
niece74814503ni_ece
nisei54214353nise_i
niseis63512023niseis
object17135803object
obtect10129633obtect
onset54730173onse_t
piece96717993pi_ece
pipet95533323pipe_t
pisco96314983pis_co
prosect11313393prosect
refect114319333refect
reject154116283reject
reseat64131493reseat
resects94115593resects
resent63833623resent
reset55051863rese_t
respect11412033respect
rident7520193rident
rifest93114583rifest
ripest84317943ripest
rise45945233rise__
risen54621883rise_n
riser55431053rise_r
risers64624783risers
rises55244043rise_s
rivet85636363rive_t
roset55945243rose_t
seat47575563__seat
sec55945323__sec_
secs65033893__secs
sects75622893__sects
select82621173select
sent46963013__sent
sept65844363__sept
set36681253__se_t
sett45949053__sett
sext117338093__sext
silent64125843silent
sises55233833sise_s
subsect112611843subsect
suspect1158513suspect
tinct76126233ti_nct
trisects1035983trisects
unseat64221023unseat
unsent63820963unsent
unset54532433unse_t
upsent83314063upsent
upset73222593upse_t
vilest9416843vilest
vise75632673vise__
vised95518763vise_d
viseed105310983viseed
vises84427773vise_s
visit8320963vis_it
vivisect1643783vivisect
widest104517003widest
wise75737343wise__
wised95123343wise_d
wisely122711713wisely
wisents10249063wisents
wiser85522803wise_r
wises85633193wise_s
wist78049293wis__t
zibet16419733zibe_t

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 Filter1786911127160.373479064.3
2DLD Change Limit1127163094.95322757.1
3Display Results3093090.0963218.8
 (SQL Overall)1786913095.42232956.7
 
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.