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

226 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
bisects113713(None) 
bisect10312871bisect_
besets85718802bese_ts
bidets95215532bide_ts
bisected1336202bisected
bisector1245192bisector
bisectors1345732bisectors
bises75435622bise__s
directs102710262directs
disjects18275922disjects
dissects11279242dissects
exsects1655572exsects
insects93710842insects
misacts1139352misacts
miseats92815792miseats
resects94115592resects
sects75622892__sects
trisects1035982trisects
wisents10249062wisents
absents93510723absents
advects13276013advects
affects1535393affects
aspects1146743aspects
assents74512223assents
asserts74311793asserts
assets65617663asse_ts
basalts9358963basalts
bases75644353base__s
basest84720493basest_
basics104915123basic_s
basilects1342973basilects
baskets135111833baskets
bassets96414823bassets
bassetts10407373bassetts
basts75936933bas__ts
beats76042243b__eats
becks135522013b__ecks
bedecks1635793bedecks
beets76131443b__eets
begets96215523bege_ts
behests1235953behests
belts75931163b__elts
bents76033693b__ents
berets85822523bere_ts
beseems1175913beseems
beses75830723bese__s
beset76739133bese_t_
besmuts1134683besmuts
besots86415453bes_ots
bests75932613b__ests
bets67051443b__e_ts
biases84618433biase__s
bibelots1295133bibelots
biceps12447713bice_ps
bices95029963bi__ces
biders94822803bide_rs
bides85536773bide__s
bidet84935623bide_t_
bields94110003bi_elds
biers76225223bi_e_rs
bifaces1448063bifaces
bigeyes1335653bigeyes
bights124417963bi_ghts
bigots95015133bi_gots
bikers124517553bike_rs
bikes117529473bike__s
biles75542143bile__s
billets94516153billets
biners85023633bine_rs
bines76946793bine__s
binits85716673bi_nits
binocs1039923binoc_s
bints76130183bi__nts
bionts8612393bi_onts
biotechs15123853biotechs
bipacks1745043bipacks
bipeds11458053bipe_ds
biremes1138773biremes
biretta947243biretta
birettas1046513birettas
birses84717733birse__s
biscuits1245133biscuits
bise66437103bise___
bisecting1436973bisecting
bisection13136983bisection
bisections14136733bisections
bisectrix2051853bisectrix
bishops1437033bishops
bisks115416803bis__ks
bismuth1443723bismuth
bismuths1542533bismuths
bisons83914373bis_ons
bisques18236893bisques
bistate9313823bistate
bisters93922613bisters
bistorts10118813bistorts
bistres94017213bistres
bistros92810983bistros
biters83925243bite_rs
bites75641173bite__s
bits66148163bi___ts
bitts75022593bi__tts
bizes165923663bize__s
bleats85518613b_leats
blets75324943b_le_ts
bluets87215493blue_ts
boskets13409473boskets
bracts105617773b_racts
brents84717273b_rents
brises84927613brise__s
briskets14346563briskets
burets84321263bure_ts
buses75936013buse__s
busts75227693bus__ts
ciscos104711133cis_cos
cists76624533cis__ts
civets115212543cive_ts
cosecs105015213cosec_s
cosets85824403cose_ts
cusecs10509153cusec_s
defects134511523defects
dejects17389223dejects
deserts82513053deserts
detects104011093detects
dialects11126003dialects
didacts1186063didacts
diets66026643di_e_ts
digests93610613digests
direct93817333direct_
discepts1336743discepts
discos94915213dis_cos
discs85316263dis_c_s
discus94512113dis_cus
diseurs839403diseurs
disject17268673disject_
disseats93211503disseats
dissect103614133dissect_
dissents93411863dissents
disserts92411813disserts
diverts114412033diverts
divests114510933divests
effects1535283effects
ejects15409953_ejects
elects83315003_elects
erects84116183_erects
expects1866883expects
exsect1558503exsect_
exserts1467013exserts
filets94718953file_ts
fiscs105311883fis_c_s
fists85527543fis__ts
gists66026193gis__ts
hists86328373his__ts
ibises83610543ibise__s
inerts64517023_inerts
infects12279713infects
injects16257453injects
insect83916583insect_
inserts74013993inserts
insets64016133inse_ts
inspects1255863inspects
islets64513083_islets
kismats13257843kismats
kismets13306883kismets
kists95822113kis__ts
linecuts1094553linecuts
lisente71210703lisente
lists56628693lis__ts
misact10316693misact_
miscuts1139183miscuts
miseat82925713miseat_
misedits1147963misedits
misers85025703mise_rs
mises74740563mise__s
misfits12279663misfits
mishits122513083mishits
mismeets12297733mismeets
misseats104011683misseats
missets94516573missets
mists76633903mis__ts
nieces84112713ni_eces
niseis63512023nise_is
objects18123693objects
onsets64013543onse_ts
pieces104217273pi_eces
pipets105714773pipe_ts
piscos105112593pis_cos
prosects1239473prosects
refects124012743refects
rejects163910693rejects
reseats74319583reseats
resect84424703resect_
resents74221223resents
resets65427613rese_ts
respects1247703respects
risers64624783rise_rs
rises55244043rise__s
rivets94417113rive_ts
rosets65819953rose_ts
seats54844343__seats
secs65033893__sec_s
sect67443623__sect_
selects91912143selects
septs75420603__septs
sets45549503__se_ts
setts55124323__setts
sexts125118383__sexts
silents73514493silents
sises55233833sise__s
subsects12267903subsects
suspects1254863suspects
tincts84510803ti_ncts
trisect939733trisect_
unseats73012853unseats
unsets64116163unse_ts
upsets8409683upse_ts
viscus11428503vis_cus
vises84427773vise__s
visits9311423vis_its
vivisects1742083vivisects
wiseass1035823wiseass
wisent93516343wisent_
wises85633193wise__s
wisest95016443wisest_
wists86728523wis__ts
zibets1737743zibe_ts

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272266.78019768.0
3Display Results2262260.0802825.0
 (SQL Overall)1786912267.28024545.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.