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

125 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
bisecting143697(None) 
besetting12268422besetting
bisection13136982bisection
bisections14136732bisections
directing1338812directing
disjecting2177242disjecting
dissecting14139472dissecting
exsecting1935932exsecting
misacting1439082misacting
miseating121215432miseating
resecting122816482resecting
trisecting1345502trisecting
absenting1236993absenting
advecting1645113advecting
affecting1845233affecting
assenting1038163assenting
asserting1038663asserting
basseting1236153basseting
bassetting1344633bassetting
basting104227203bas__ting
beating104326873b__eating
becking164416073b__ecking
bedecking1934283bedecking
begetting13186583begetting
belting104119133b__elting
beseeching1843363beseeching
beseeming1435143beseeming
besotting12256873besotting
besting104923923b__esting
betting103921403b__etting
bicycling1942883bicycling
bielding12237473bi_elding
biestings12266033bi_estings
bighting15269453bi_ghting
bijection20134793bijection
bijections21134933bijections
bijective2343913bijective
bilection13156803bilection
bilections14136503bilections
billeting1236633billeting
birching16328463bi_rching
bisect10312873bisect___
bisected1336203bisect_ed
bisectional1554633bisectional
bisector1245193bisect_or
bisectors1345733bisectors
bisectrix2051853bisectrix
bisects1137133bisect__s
bishoping1744283bishoping
bisontine1145673bisontine
bitching163610623bi_tching
bitewing1435293bite_wing
biting95321823bi___ting
bitting103717293bi__tting
bleating113514503b_leating
breeching17236473breeching
busting104221793bus__ting
caseating12311743caseating
defecting162510223defecting
dejecting20217793dejecting
deserting11713143deserting
detecting13259983detecting
dieting93616833di_e_ting
digesting12208673digesting
discepting1658473discepting
discing113914593dis_c_ing
discoing12511453dis_coing
diseasing11310833diseasing
disputing1337763disputing
disrating11714553disrating
disseating121111783disseating
dissenting121310293dissenting
disserting121310853disserting
diverting142410333diverting
divesting14298483divesting
effecting1845583effecting
ejecting18268163_ejecting
electing112113783_electing
erecting112415063_erecting
expecting2146693expecting
exserting1736663exserting
fileting1239303file_ting
fisting113818123fis__ting
histing113720373his__ting
ideating10311703_ideating
infecting15109673infecting
injecting1997693injecting
inserting10914233inserting
insetting1079283insetting
inspecting1546223inspecting
listing84020593lis__ting
misciting1439673misciting
miscuing1338733mis_cuing
misdating131010663misdating
misediting1446573misediting
mismating141211823mismating
mismeeting1546243mismeeting
misrating121014853misrating
misseating131310943misseating
missetting13107903missetting
misting103623383mis__ting
objecting2144053objecting
piecing12410453pi_ec_ing
pipetting1435513pipetting
prosecting15189813prosecting
refecting152413353refecting
rejecting192211153rejecting
reseating102421533reseating
resenting102619293resenting
resetting102816293resetting
respecting1549883respecting
riveting12139443rive_ting
rivetting13256413rivetting
seating84130683__seating
selecting12310533selecting
setting83621393__setting
suspecting1565703suspecting
tincting1148883ti_ncting
unseating10713203unseating
unsetting1088993unsetting
upsetting1275563upsetting
viseing11299163vise__ing
visiting1238393vis_iting
vivisecting2051963vivisecting
wisting113519743wis__ting

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 Filter1786911486410.1601116818.8
2DLD Change Limit1486411257.71619264.0
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.92222556.3
 
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.