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

124 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
bisected133620(None) 
bisect10312872bisect__
bisector1245192bisector
bisects1137132bisect_s
directed1238232directed
disjected2086352disjected
dissected13108662dissected
exsected1835672exsected
misacted1338672misacted
resected112514742resected
trisected1244912trisected
absented1156613absented
advected1534533advected
affected1744793affected
assented957513assented
asserted957903asserted
basseted1136753basseted
bassetted1244703bassetted
basted95227233bas__ted
becked155417763b__ecked
bedecked1874573bedecked
belted94020633b__elted
beseeched1743203beseeched
beseemed1334863beseemed
besetter10137983besetter
besotted1135843besotted
bested94922763b__ested
betted94721163b__etted
bicycled1843133bicycled
bielded11226713bi_elded
bighted142810923bi_ghted
bigoted11258403bi_goted
billeted1137643billeted
bilsted1038033bi_lsted
bimester1236163bimester
biparted1335133biparted
birched15349913bi_rched
bisecting1436973bisecting
bisection13136983bisection
bisectors1345733bisectors
bisectrix2051853bisectrix
bishoped1644663bishoped
bistate9313823bistate_
bister84922763bis__ter
bistered112913333bistered
bistred103311853bis_tred
bitched153212923bi_tched
bitted94418483bi__tted
bleated104015973b_leated
bracted12410933b_racted
breeched16337383breeched
busted95123153bus__ted
caseated11310713caseated
cisted95217523cis__ted
defected15289973defected
dejected19307593dejected
deserted101012203deserted
detected12289733detected
dieted83115493di_e_ted
digested11208163digested
directer1137583directer
disced104914653dis_c_ed
discepted1547523discepted
discoed11312483dis_coed
diseased103011713diseased
disputed1238353disputed
disrated10915573disrated
disseated11711083disseated
dissented1199723dissented
disserted11109813disserted
diverted13199583diverted
divested13268213divested
effected1744993effected
ejected17297653_ejected
elected102812613_elected
erected103213993_erected
expected2036743expected
exserted1636213exserted
fileted1159093file_ted
fisted104218703fis__ted
histed104420243his__ted
ideated9310973_ideated
infected14229403infected
injected18226753injected
inserted92413053inserted
insetted9249023insetted
inspected1445403inspected
invected14258883invected
isleted837523_isleted
lineated9711063lineated
lisente71210703lisente_
listed74322833lis__ted
miscited13310423miscited
miscued1239293mis_cued
misdated121211123misdated
miseaten10310773miseaten
misedited1346783misedited
misenter10310833misenter
mismated131111333mismated
misrated111315383misrated
misseated12610113misseated
misted93625823mis__ted
objected2043493objected
obtected1344553obtected
pieced113912103pi_ec_ed
pileated112711133pileated
pipetted1335263pipetted
prosected14158633prosected
refected142311663refected
rejected182710113rejected
reseated93220263reseated
resented92716963resented
respected1438493respected
riveted11258573rive_ted
rivetted12226093rivetted
seated75131063__seated
selected1159783selected
suspected1444383suspected
tincted1037273ti_ncted
unseated91317683unseated
viseed105310983vise__ed
visited1168773vis_ited
vivisected1951413vivisected
wisted104120273wis__ted

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621247.64019131.2
3Display Results1241240.0631968.3
 (SQL Overall)1786911248.12621990.0
 
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.