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

287 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
disbars1031032(None) 
disbar938511disbar_
busbars1138152busbars
darbars10510092darbars
debars94218042d_ebars
dibbers124013172dibbers
dinars75417562di_nars
disarm9310472dis_arm
disarms1039042dis_arms
disband1138242disband
disbands1237352disbands
disbuds11125242disbuds
disburse1186442disburse
discard11310212discard
discards1238912discards
diseurs839402diseurs
dismals102010242dismals
dismays13237432dismays
dispart101115282dispart
disparts11109952disparts
durbars1077972durbars
isbas71010402_isba_s
isobars936592_isobars
mimbars1397382mimbars
airbags1036293airbags
bars66564093___bars
bibbers103911353bibbers
bisters93922613bisters
busbar1038453busbar_
casbahs1436463casbahs
cigars9910723ci_gars
costars94218013costars
dabbers123813213dabbers
damars93814993d_amars
dammars12308193dammars
darbar959953darbar_
dashers115016863dashers
dastard9279703dastard
dastards10278083dastards
daubers104610423daubers
daystars1243903daystars
dears65736883d__ears
debags104211063d_ebags
debar85517863d_ebar_
debark134210943d_ebark
debarks14388493d_ebarks
denars74621433d_enars
deodars937623deodars
desmans1039003desmans
despairs1144943despairs
desugars1043373desugars
dewars105117073d_ewars
diabase1037113diabase
diabases1137223diabases
dialers83614303dialers
dials64925343di__als
diapers104713913diapers
diapirs10347643diapirs
diary95016973di__ary
diasters92913183diasters
dibber114614713dibber_
dibblers13377583dibblers
dibbles124013333dibbles
dibbuks1643163dibbuks
dibs76233683di_b__s
dicers94720743di_cers
dickers144117663dickers
dieback1646913dieback
diebacks1745963diebacks
diehard1237053diehard
diehards1346213diehards
diesters92513603diesters
dietary1158663dietary
dieters83216433dieters
differs14339973differs
diggers104413393diggers
dikers114418793di_kers
diktats1235623diktats
dimers94321093di_mers
dimmers123811563dimmers
dinar66319893di_nar_
diners75525953di_ners
dingbats1245013dingbats
dingers94321383dingers
dinners83915443dinners
diobols1036543diobols
dioxans1555313dioxans
dippers123615183dippers
dipsas9359893dipsa_s
diquats1745983diquats
dirams94413703di_rams
dirhams13376313dirhams
dirtbags1242703dirtbags
disable10516433disable
disablers1255803disablers
disables11410903disables
disabuse1145553disabuse
disbarred1345273disbarred
disbud10165713disb_ud
disbursal1243223disbursal
disbursed1365763disbursed
disburser1254913disburser
disburses1266743disburses
discant103017263discant
discants112912023discants
discase102912863discase
discases112014503discases
discern1038493discern
discerns1138163discerns
discord1139993discord
discords1238593discords
discos94915213dis_cos
discs85316263dis__cs
discus94512113dis_cus
discuss10357953discuss
disdain938513disdain
disdains1037913disdains
disease83213843disease
diseases92415813diseases
disembark1853433disembark
disembarks1953123disembarks
diseur738843diseur_
disfavors1643263disfavors
dishes104622653dis_hes
dishpans14115833dishpans
dishrag1246273dishrag
dishrags1346203dishrags
dishware1545433dishware
dishwares1645863dishwares
disks105417473dis__ks
dismal92412243disma_l
dismast10311233dismast
dismasts1137513dismasts
dismay12229473disma_y
dismes95617673dis_mes
dismiss1038153dismiss
disobeys1443683disobeys
disowns1136733disowns
dispels10310503dispels
disperse111011353disperse
displays1446293displays
disport101015953disport
disports111111113disports
disrate81418523disrate
disrates91118153disrates
disrobers1246383disrobers
diss56434483dis___s
dissave1139413dissave
dissaves1239413dissaves
disseats93211503disseats
dissert83720693dissert
disserts92411813disserts
disses75225963dis_ses
distaff1467683distaff
distaffs1565083distaffs
distain8313783distain
distains9413603distains
distal73615773dista_l
distant83519953distant
distaves12311403distaves
distils83015803distils
distort81120333distort
distorts91112353distorts
disturb1046233disturb
disturbs1145403disturbs
disuses84015413disuses
ditas65923673di_ta_s
dithers114016153dithers
divans104612393di_vans
divas95418583di_va_s
divers105024963di_vers
diwans105110373di_wans
dobbers123513253dobbers
dobras94811913d_obras
dogears937513dogears
dollars83311023dollars
dosers75723633dos_ers
dossals8379293dossals
dossers84516233dossers
drawbars1483103drawbars
drears74614253d_rears
dubbers124011823dubbers
durbar968723durbar_
dusters84918363dusters
embars103812883_embars
escars83913133_escars
eskars10357593_eskars
eyebars1245333eyebars
fiars86720833fi__ars
fibbers144510603fibbers
fibers114717523fi_bers
fiscals1238003fiscals
fishers134714723fishers
gasbags1135473gasbags
gibbers124710983gibbers
gibers95114663gi_bers
gimbals12257823gimbals
hissers104112313hissers
hussars10326983hussars
imbark14347863_imbark
imbarks15326613_imbarks
instars7411133instars
invars9310003_invars
isba61310883_isba__
isobar836143_isobar_
isobare946343_isobare
isobares1046513_isobares
izars145112933_i_zars
jibbers18449703jibbers
jibers155912883ji_bers
kabars124513953_kabars
kasbahs1634363kasbahs
kbars114612603__kbars
kebars124112493_kebars
kilobars1444933kilobars
kismats13257843kismats
kissers114211293kissers
kitbags1443883kitbags
lascars979013lascars
liars54723163li__ars
libbers113812833libbers
libers84721443li_bers
libras83711703li_bras
lidars7310783li_dars
limbas105313203limba_s
limbers113614743limbers
lispers94514323lispers
listers74026533listers
lumbars11289763lumbars
mimbar1297493mimbar_
minibars1296553minibars
misbias1139083misbias
miseats92815783miseats
misers85025703mis_ers
mishaps1438723mishaps
mishears1338323mishears
miskals13369763miskals
mislays12349243mislays
mismark1536703mismark
mismarks1645893mismarks
misparse1237733misparse
mispart111113783mispart
misparts12108173misparts
missals93914423missals
missays124010253missays
misters93927513misters
pibals103813083pi_bals
pillars9313493pillars
piscary1437423piscary
pishers123815753pishers
pissers95014753pissers
qindars17267423qindars
qintars16268573qintars
rebars84019833_rebars
ribbers113913183ribbers
risers64624783ris_ers
riskers114011993riskers
ristras7311563ristras
sambars115113843sambars
scars75433533__scars
sears54744913__sears
sidebars1146643sidebars
simars84916933si_mars
sirdars8228213sirdars
sisals63013573sis_als
sisters73721593sisters
sitars65417593si_tars
sizars154812623si_zars
soars54732513__soars
spars75431543__spars
stars55836573__stars
taskbars1452993taskbars
timbals11239533timbals
timbers113111853timbers
tsars56717113_ts_ars
tussars7359253tussars
unbars82113033_unbars
upsoars985413upsoars
vicars11712263vi_cars
visard103910123vis_ard
visards11328153vis_ards
visas84317653vis_a_s
visors92912223vis_ors
vistas94513273vista_s
visuals1036853visuals
wiseass1035823wiseass
wishers133215213wishers

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.406440125.6
2DLD Change Limit1340272877.00019146.7
3Display Results2872870.1102609.1
 (SQL Overall)1786912877.51623774.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.